SQLTeam.com | Weblogs | Forums

Disable SSRS parameter when another parameter is selected


#1

I have four parameters on my SSRS report. 1. Start date 2.enddate 3.year. 4.quarter. All are drop downs that are being populated using sql query . Whenever the parameters for year and or quarter is selected. I want to disable. The parameters for start and end date and the vice a Versa , if I select a start and end date Then the parameters for year and quarter should be disable. Disable meaning they can see but cannot select any values its basically grayed out. Any suggestions


#2

Your answer to this might lie in Linked reports:
https://msdn.microsoft.com/en-us/library/ms155889.aspx

It might not be exactly disabling other params, but it would allow you to force a specific output. let me know if it works out for you.