Geek asks and answers

SSRS - changing a parameter value does not resume my report again

I have a report with two parameters, which are datetime, @startdate and @enddate.

I set them under "advanced settings" to "Automatically detect when to update" (also tried "Always update") for both parameters.

I unrolled my report and ran it. The date is changed and a callback message appears (the screen blinks and the browser indicates the lower left corner of the activity), but I end up with a blank screen (I still have my top, but everything below is empty). If I click the View Report button at the end of the header area, it will start it again, but I intend to restart the report when any parameter changes.

Not sure what I did wrong. I am using SSRS 2008, and that was what I was able to do in previous versions of SSRS.

+3
source share
2 answers

If you hard-code the default value of a parameter, for example 1/1/2000, it does not consider it necessary to update it completely (this gives you an empty report, though!). The solution is to point it to a query (data set) that selects a date estimated at 1/1/2000. And I think that for a few parameters you should set all the defaults this way. Awful.

-1
source

you need to expand your report before passing parameters and once after passing parameters. what fixes the problem for me

-1
source

More articles:


All Articles