We had an annoying problem with a published SSRS report in SharePoint that uses a Parameter.
Most likely this appears only in combination with a external data source like an ODBC connection that retrieves data from a data source not within the current domain ?
This strange ‘bug’ I would call it so far is not showing when your run the report from within the Report Designer, but only from within SharePoint.
So I suspect that this is a malfunction in the SSRS front end Web Part.
When selecting the first time a parameter in the report, it returns all the filtered data. But when selecting a new parameter value, for the second time, it returns a blank page ? And the parameter box jumps down.
After debugging with trial and errors, we found out that if you add a Default Value, in the parameter field, the problem is solved.
If you get the parameter values from a different Dataset, you can also specify the Default Value using the Get Values from a Query option. But this is not needed to make it work.
Just give any valid default value in the Specify Values field will do the job as well.
Again, this problem is not occurring in the Report Designer itself?
So the SharePoint users are happy to see that this annoyance is gone