Dynamic Default Date Parameters in SQL Server 2000 Reporting Services

June 21, 2005

[From Developer.com]

SQL Server 2000 Reporting Services offers a robust report parameter interface that is exposed through the report designer, its Web service interface, the report manager, and via scheduled reports. The fact that this interface supports dynamic default parameters is essential to providing timely intelligence to consumers with minimal interaction.

Many business intelligence reports depend on date parameters based off of the current date. For example, a revenue report might need to be run at the beginning of each month, representing data from the previous month. Other examples include weekly or daily summary reports.

To facilitate serving this common need, I've created a series of database objects to calculate commonly used relative dates, and outlined the process for adding a list of commonly referenced dates as a dataset in the report designer. These dates then can be added as default parameters.

The article continues at http://www.developer.com/db/article.php/3513996