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

Change the parameters based on Main Parameter Expand / Collapse
Author
Message
Posted Thursday, August 16, 2012 10:51 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:25 AM
Points: 151, Visits: 422
Hi All,

I've report that has 4 parameters, say ParA, ParB, ParC and ParD.
ParA is the main parameter upon which other parameters are dependent

If ParA = 'X' then the user should be able to select options from ParB and ParC (ParD should be hidden)
If ParB = 'Y' then the user should be able to select options from ParD (ParB and ParC should be hidden)

I really appreciate if someone could assist me with this.

Thanks in advance!
Post #1346119
Posted Thursday, August 8, 2013 11:53 AM


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 #1482504
Posted Monday, September 30, 2013 8:30 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Agree with Snigdha. It's not supported in SSRS.
Post #1500249
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse