SSRS - parameter value change is not running my report again

Question

I have a report with two params that are datetime, @startdate and @enddate.

I have set them up under "advanced settings" to "Automatically determine when to refresh" (also tried "Always refresh") for both of the parameters.

I deployed my report and ran it. Changed the date and it appears the report fires a postback (screen flashes and browser indicates activity bottom left corner) but I end up with a blank screen (I still have my breadcrumb up top but everything below is blank). If I hit the "view report" button on the end of the header area it will run it again but my intention is to re-run the report when either parameter changes.

Not sure what I did wrong. I'm using SSRS 2008 and this was something I was able to do in the past versions of SSRS.

Answer 1

If you hard code a default parameter value, like 1/1/2000, it doesn’t think it needs to refresh all the way (it gives you a blank report though!). The solution is to point it to a query (dataset) that selects a date valued at 1/1/2000. And I think for multiple parameters, you have to set all default values this way. Pathetic for sure.

Answer 2

you need to deploy your report, once before you pass the parameters and once after you pass the parameters. that fixes the issue for me