Simple Cascade Parameters not updating

  • TexasJohn

    Default port

    Points: 1476

    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/e.i.e.i.o.

  • Site Owners

    SSC Guru

    Points: 80385

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply