Hiding/Collapsing Report Sections

I have lot of information to display on one report. I am trying to come up with a reasonable layout, that could include all the information on one page without over whelming the user. Essentially I would like to divide the report in three sections, ideally with a collapse/expand functionality. Is it possible with Reporting services. How?

- Section1 Heading....(Expanded/Visible)

<Table, text boxes, lists go here>

<data region>

<data region>

<...>

<...>

+ Section2 Heading (Collapsed/Hidden)

<Table and other data regions are hidden>

+ Section3 Heading (Collapsed/Hidden)

<Table and other data regions are hidden>

Any help will be appreciated.

Thanks.

DNG

This is possible using the visibility and toggle properties of report items. Experiment with tables, one for each section. You can add extra header/footer rows as appropriate for your lists and other fields. The same can also be accomplished using rectangles, but I haven't heard good results on the layout of rectangles when rendered in production. It all depends on how the report will be laid out, but in the end, the primary properties are visibility and toggle.

Simone

|||

Very Cool. I am able to use the text box as toggle item but have to use rectangles as it needs to contain multiple tables and other data regions..Hopefully it wont do anything funky in production.

Thanks much.

DNG

hiding null rows from a matrix

All,
I have a matrix that is being populated by a sproc.
The sproc returns data which are broken into sections by fields and
then sorted by another field.
The matrix is group on the section designator.
However, each section is getting an initial row that is null.
I want to drop out the null rows from the matrix.
I am not allowed to change the sproc.
Thanks in advance,
MI have a couple of typos and things to add.
I was trying to say that the matrix is grouped on the section
designator.
within each section this is a null row showing up.
I just want the matrix to filter out the nulls.
I don't have that option to do it from within the sproc.|||Hi Max,
Did you find a solution for this, even I am facing the same problem, I need
to hide the empty rows in a matrix.
Please reply back if you have found any solution for this.
Thanks,
Kiran