How can I expand and contract a column

rhservan
rhservan used Ask the Experts™
on
In my report I have 4 columns. The fourth column presents a list.  The other 3 columns are just single line text.

Col1     Col2       Col3      Col4
XXX     XXX       XXX      XXX
                                       XXX
                                       XXX
                                       XXX
                                       XXX
XXX    XXX        XXX      XXX
                                       XXX
                                       XXX
                                       XXX
I would like to expand or contract column 4 so only a single line shows with col1,2&3 Or I can expand it and view the entire list.  
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can use ssrs drilldown reports.
Here is an example
http://www.mssqltips.com/tip.asp?tip=1329

Author

Commented:
Thanks for your response on this. Just a note in the tag for my problem I entered "SSRS 2008". The response provided was for "SSRS 2005"  However, from the information that was provided it assisted me to find the missing information for my 2008 implementation.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial