Search code examples
reporting-servicesparametersreportviewer

How do I make SSRS ReportViewer wait until parameters are entered before rendering?


I have an SSRS report that's called up by a page with an ASP.Net ReportViewer object. The report takes parameters for filtering. Right now when the page is first called up, there are default values in the parameters and the viewer just takes off and renders a report with those settings. I thought this would be a nice time-saver, but my client complains that this takes several seconds, so what we want to do now is have it just wait until I hit "View Report" before it tries to render anything.

What's the best approach? Not set defaults to the param's? Set the ShowReportBody to false? Something else? Seems like this should be simple.


Solution

  • Removing the default should will make the report not render. I think that's your only option. And also the simplest.

    If some clients like the old behavior, you could provide defaults programatically for certain users. (IE, store a browser cookie that tells your page to provide defaults if they check a "save defaults" checkbox.)