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 the report parameters when i click on the View report button

hi All,
i am working in SQL reporting services 2005, i have requirement that i
need to show all the report parameters in the report layout and user
can enter or select the values when i click on the view report button,
the report parameters should be hided. i am not sure that we could hide
the report parameters when i click on the view report button.
anyone knows how to implement this. please let me know.
Thank you in advance.
VinodAny idea on the below issue!!!!
thanks
Vinod
Vinod wrote:
> hi All,
>
> i am working in SQL reporting services 2005, i have requirement that i
> need to show all the report parameters in the report layout and user
> can enter or select the values when i click on the view report button,
> the report parameters should be hided. i am not sure that we could hide
> the report parameters when i click on the view report button.
> anyone knows how to implement this. please let me know.
> Thank you in advance.
> Vinod