SQL Server Reporting Services Logging & Caching project released on Codeplex


The first version ( of a small project I did was published to Codeplex (http://rsparamlogcache.codeplex.com/). It enables you to log and cache user parameter values for further usage and statistics. Here is short extract from the project description:

Project Description
The solution tracks the selected parameters from a report execution and uses them later for the next execution to take them as default parameters. This enables users to log parameters and inspect the execution statistics of reports as well as caching former execution parameters.

Short extract
The basis for this are two tables (one which tracks the global execution information like ReportName and ReportUser) and one for the parameters. The according procedures are one to do the logging and store the parameter values and another one to get the values back for future report calls of that user. The procedure are capable to handle all available data types in reporting services as well as Nullable parameters and multivalve parameters.
The basis on the frontend (the report execution) is a simple custom code (mainly based on the information of the blog post above) which includes the logic to collect the parameters as well as a small implementation to hash the user information (as in most countries you are not allowed to track user sensitive data without a specific reason)

Simple and easy to implement.

Feel free to give any feedback, comments, suggestions or feature requests.


Comments (1)

  1. david says:

    Intesting project. Here is another on codeplex that provides full Reporting Services execution log analysis for management reporting..including most frequently used parameters for a report.