SSRS 2000 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSRS 2000

Author

Topic

Gururaj
Starting Member

5 Posts

Posted - 2011-07-04 : 23:44:46

I have a report that has a lot of details to it. However until someone drills down to a certain degeree I want entire columns to be hidden until the drill down is selected.

Has anyone found an answer to this ?

Example... the last row is set to hide
the Display can be toggled by this report has a field selected. for the grouping of the drill down.

Gururaj Bhande

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-05 : 13:54:44

there is a property called toggle visbility based on report item. you should use it and link the visbility of last row to group above.

see
http://www.sqlchick.com/entries/2010/12/21/visibility-settings-in-ssrs-drill-down-to-showhide-report-da.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Gururaj
Starting Member

5 Posts

Posted - 2011-07-06 : 01:06:11

Thank you :-)

Gururaj Bhande

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources