August 23, 2019 at 4:04 pm
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.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
August 24, 2019 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply