Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

hide a parameter based on the value of another parameter Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 2:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668
Hi geniuses!

Is there a way in SSRS to hide a report parameter based on the value of another report parameter?

Thanks

Post #1475325
Posted Friday, July 19, 2013 2:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 13,622, Visits: 10,514
Apparently not:

http://www.bidn.com/forums/microsoft-business-intelligence/reporting-services/190/can-we-hide-the-parameter-based-on-the-value-of-another-parameter




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1475329
Posted Thursday, August 8, 2013 12:43 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:41 PM
Points: 522, Visits: 234
Hi,

By design, the parameters will be rendered while the report is processing. This means there is no option to hide a parameter at run-time .

I would suggest you implementing a custom parameter interface using ASP.NET, and then using Report Viewer control to display the report.

Please refer:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c233cf39-bff3-4519-8459-58b24e82ec29/conditionally-hiding-parameters-in-ssrs-2005

Thanks
Post #1482524
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse