I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005.
Here is my scenario.
I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate
Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled.
When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled.
I have done google search on this issue and found out that this is not possible at run time.
Is there any alternative for this issue?
If the above is not possible, I would like to get atleast in this way :
When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL.
When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL.
I am not sure whether this is possible or not....but just trying to get in some way.
Here is the query used in MonthDataSet :
Select Month_Code, Month_Name from MonthTable.
View Complete Post