Adding Expand/Collapse feature to SSRS textbox

Question

Adding Expand/Collapse feature to SSRS textbox

Vishal Singh

SSCertifiable

Points: 5830
More actions
October 25, 2010 at 2:16 am

#230785

Hi,
I have a simple query to fetch First_Name, Middle_Name, Surname from a table along with few other fields.
I have Matrix control on my Report designer. What I am looking for is to, in the matrix the top level (fields) it should just appear as Name (with a collapse/Expand button) if somebody expands it then it should show the names as First_Name, Mid_Name, Surname..
I read from somewhere that I need grouping first but not very sure where and how in my case.
Can somebody put some thoughts on how to do this SSRS 2008?
Thanks
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]
October 25, 2010 at 4:46 am

This was removed by the editor as SPAM
October 25, 2010 at 4:48 am

This was removed by the editor as SPAM
October 25, 2010 at 6:50 am

This was removed by the editor as SPAM
October 29, 2010 at 12:45 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 1

stewartc-708166 (10/25/2010)
Please refer:
SQL2008:http://msdn.microsoft.com/en-us/library/ms157454.aspx
SQL2008 R2: http://msdn.microsoft.com/en-us/library/dd207042.aspx

Thanks. I am currently going through this. I will let you know if this helps me.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

Vishal Singh (10/25/2010)
stewartc-708166 (10/25/2010)
Please refer:
SQL2008:http://msdn.microsoft.com/en-us/library/ms157454.aspx
SQL2008 R2: http://msdn.microsoft.com/en-us/library/dd207042.aspx
Thanks. I am currently going through this. I will let you know if this helps me.

Thanks stewartc-708166 ,

This work like a charm.

Can we also take care of the positioning part. Like in the current method, if the Full name is not visible still there is space reserved for it. Can we do something like, if this is not visible, then space can be occupied with adjacent columns and when its visible, the adjacent columns can be slide left or right...

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 3

stewartc-708166 (10/25/2010)
This will require some custome code in the textboxes, e.g.
=iif(ISNULL( firstColumn .value ) == true, secondColumn.value, firstColumn .value)

Can you explain a little more about this or suggest any article from where I can learn this.

Once again Thanks for the help..

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]