When previewing a report it doesn't change the data when I change the value

• Doctor Who 2

  SSCrazy Eights

  Points: 8177

  More actions

  July 18, 2019 at 3:58 am

  #3663986

  Got some unusual behavior. I've finished writing a SSRS report that gets data from an older version of MySQL (5.1.41). It runs using a view written by a colleague. I've added a bit of logic to filter the data:

  SELECT        Case Number, Case Status, Assigned, Investigation Due, 
  Investigation Completed, Report Due, Report Submitted, Closure Due, 
  Closed, Contractor, Investigator, Region
  FROM            secretarysreport
  WHERE        ((Region = @Region) OR
                           (@Region IS NULL))

  If I take the query and put it into MySQL Workbench to run it, specifying something like NW for the region, it works fine. However, when I preview it in Visual Studio 2017, then change the selection (I've specified all valid values for Region), it doesn't change the data returned. Why is that? Why isn't the preview showing the changed value I've chosen when I view it in preview?

  • This topic was modified 4 years, 9 months ago by  Doctor Who 2.

  Rod

• Andrey

  Right there with Babe

  Points: 780

  More actions

  July 18, 2019 at 9:25 am

  #3664073

  Studio caches data and uses it for previews.

  Data is stored in .data files in the same folder where your report resides.

   

  How to clean :  either manually  or  in automated way (see link below)

  https://www.sqlmsbi.com/how-to-clear-cache-in-ssrs-visual-studio/

   

• Rod at work

  SSC-Dedicated

  Points: 33900

  More actions

  July 18, 2019 at 2:10 pm

  #3664170

  Andrey, I've gotta admit, I didn't see that comin'. OK then, thank you!

  Kindest Regards, Rod Connect with me on LinkedIn.