Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Jun 21, 2005

Dynamic Default Date Parameters in SQL Server 2000 Reporting Services

By DatabaseJournal.com Staff

[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

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM