Dynamic Default Date Parameters in SQL Server 2000 Reporting Services

Tuesday Jun 21st 2005 by DatabaseJournal.com Staff

Many business intelligence reports call for date-driven parameters. These parameters are often based on the current date. Learn how to develop a DataSet of commonly used dates and use this DataSet to populate the default parameters in a SQL Server 2000 Reporting Services report.

[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

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved