Simple Cascade Parameters not updating

• TexasJohn

  Default port

  Points: 1476

  More actions

  August 23, 2019 at 4:04 pm

  #3674019

  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.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  August 24, 2019 at 4:10 pm

  #3674188

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.