Wednesday, March 7, 2012

Parameters Disabled with Snapshot Report Execution

Is there a way to schedule report snapshots and still give users the option to change the parameters? I found that report parameters are disabled when I set the execution options to use a snapshot. I fixed the problem by setting the report to use cached data that expires on a custom schedule and by scheduling an e-mail subscription that creates a new report cache soon after the cache expires. I'm guessing there must be a better way to provide good report performance with the default parameters as well as flexibility.

You'd need to change from using Query Parameters the query to using Report Filters.

You can read about it here:

http://msdn2.microsoft.com/en-us/library/aa255838(SQL.80).aspx

I would only recommend doing this for filtering relatively small amounts of data. The SSRS is not as efficient at filtering data as a stored proc on a DB server.

No comments:

Post a Comment