I have a parameter called SearchCriteria with four Available Values R, W, M, or A for Range of Dates, Last Week, Last Month, or Last Year respectively. I have another parameter to include a statistics Table at the End of the Report. For all but the Range of dates I want the stats table to display. A simple response of Y or N. I created a stats dataset with a simple query...
SELECT CASE WHEN @SearchCriteria = 'R' THEN 'N'
WHEN @SearchCriteria = 'W' THEN 'Y'
WHEN @SearchCriteria = 'M' THEN 'Y'
WHEN @SearchCriteria = 'A' THEN 'Y'
END AS Value
Yes, I know I could have just used an ELSE but I have tried every thing I can think of to make this work, including writing inefficient code. The Stats drop down has two available Values, Y or N. The first time I select a criteria the drop down updates properly. After that it never updates again. I've used cascading parameters in the past and never had a problem. I've tried every trick I can think of and am embarrassed to be asking something so simple, but I'm really vexed by this one. I even set up a text box to the same Dataset and it does not update either.
SQL Rebel without a Where Clause