Hide show sections
Is there a way to hide and show sections on a report based on a Parameters Value?
April 21st, 2011 9:46am
Yes you can write a expression based on parameter in hidden propertyBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 9:49am
Hi,
Have you tried Visibility Section for the ReportItem.
Thanks
KumarKG, MCTS
April 21st, 2011 9:49am
Hi,
Kindly have a look at below two posts and see if this helps
http://www.bidn.com/blogs/MikeDavis/ssis/816/ssrs-hide-or-show-some-or-all-columns-on-a-report
http://msdn.microsoft.com/en-us/library/ms159830.aspx
The first post is to hide column as per parameter, you need to hide the data region as mentioned in second link.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 9:51am
Hi,
you have to write an expression in the visibility property of the controls, the control will be visible based on the parameter value.
Thanks,
Shobhit
April 21st, 2011 10:06am