i have a time dimension table in sql with years, months , quaters date related data.........

i have 4 filters in ssrs: 1)period of frequency(values: monthly,quaterly,halyearly,yearly)   2)month   3) quaterly 4)halyearly      5)yearly

if i select period of frequency as monthly then 2nd & 5 th filters should be enabled for selection

if i select period of frequency as quaterly then 3rd & 5 th filters should be enabled for selection

if i select period of frequency as halyearly then 4td & 5 th filters should be enabled for selection

if i select period of frequency as yearly then  5 th filters should be enabled for selection

how to achieve it in ssrs

Hi Santoshkum, 

According to your description, you want to enable the Filters based on a report parameter value, right? 

Hi Santoshkum, 

According to your description, you want to enable the Filters based on a report parameter value, right? 

In Reporting Services, if you want to disable the filters, we can use a report parameter to control the availability. In you scenario, if you want to enable or disable the filters , you can use IIf() function to return the required result based on the report parameter value. For your requirement, please refer to the following steps: 

1. Modify the filter as below: 
2. If parameter test value is not 1, the IIf() function will return null value, and then the filter is not available. 

The result is like below: 

If you have any other question, please feel free to ask.

Regards,
Shrek Li

• Edited by Shrek LiMicrosoft contingent staff, Moderator 23 minutes ago