Hide Columns

Hi,
I have created a report that contains a table. The table returns data w/
multiple statuses. I have created a group based on the status and have a
page break at the end of the group (so each page will display only one status
type). I would like to dynamically show / hide columns based on the status.
Is this possible? I tried setting the visibility of the individual cells,
however, this leaves a gap where the cells were (which is not desirable)â?¦
Any thoughts?
Thanks!Try setting the visibility property on the column instead of the
individual cells.
On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a report that contains a table. The table returns data w/
> multiple statuses. I have created a group based on the status and have a
> page break at the end of the group (so each page will display only one status
> type). I would like to dynamically show / hide columns based on the status.
> Is this possible? I tried setting the visibility of the individual cells,
> however, this leaves a gap where the cells were (which is not desirable)...
> Any thoughts?
> Thanks!|||Hi Jen,
Can this be done with a Cross-Tab Report? I dont see the Visibility Property
of the column group :( .
--
With Thanks and Regards,
Raja Krishnamurthy
"Jen" wrote:
> Try setting the visibility property on the column instead of the
> individual cells.
> On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have created a report that contains a table. The table returns data w/
> > multiple statuses. I have created a group based on the status and have a
> > page break at the end of the group (so each page will display only one status
> > type). I would like to dynamically show / hide columns based on the status.
> > Is this possible? I tried setting the visibility of the individual cells,
> > however, this leaves a gap where the cells were (which is not desirable)...
> >
> > Any thoughts?
> >
> > Thanks!
>
>

HELP: SQL SERVER CONNECTION TIMED OUT

can someone please help me solve this problem.

i'm experiencing sql server error: the database controller returned an error status of sql server connection timed out.

i need some help badly.

thanksWhat is the code doing when it times out? Frequently this is a problem with running a long script that exceeds the timeout. What is the complete text of the exception message?

Don|||>>what is the code doing when it times out?
- the code is posting accounting transactions coming from our accounting system.

>>the complete error message?
- the database controller returned an error status of sql server connection timed out

thanks|||Regarding the complete error message, I mean the full page of stuff that you get by default in ASP.NET, including the full error message, stack trace, and everything else that probably looks useless on the page.

That said, how long is the process taking? You may have to extend the SQL connection time out and perhaps the page time out.

Don

Help: Messages stuck in sys.transmission_queue

For some reason the messages are stuck at sys.transmission_queue. The transmission status seems to be null. I verified all the Queues and they hae the values of (is_receive_enables = 1, is_enqueue_enabled = 1, is_activation_enabled = 0)

I have set up the service broker on different domain and have bidirectional ports open to receive messages.

I can send and receive messages, when I run the same service broker setup scripts at the machines that belongs to same domain .

any help appreciated.

Do you have anything picking up the messages from the queues? You have is_activation_enabled = 0. Have you tried associating an sp with a queue ?

Tim|||

Thanks Tim... I figured out the issue. The 2 servers we used are in different domain and have firewall. The ports open for service broker were not bidirectional.

Help: Messages stuck in sys.transmission_queue

For some reason the messages are stuck at sys.transmission_queue. The transmission status seems to be null. I verified all the Queues and they hae the values of (is_receive_enables = 1, is_enqueue_enabled = 1, is_activation_enabled = 0)

I have set up the service broker on different domain and have bidirectional ports open to receive messages.

I can send and receive messages, when I run the same service broker setup scripts at the machines that belongs to same domain .

any help appreciated.

Do you have anything picking up the messages from the queues? You have is_activation_enabled = 0. Have you tried associating an sp with a queue ?

Tim|||

Thanks Tim... I figured out the issue. The 2 servers we used are in different domain and have firewall. The ports open for service broker were not bidirectional.