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