Subscription parameter

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: Subscription parameter

Dangermouse

Subscription parameter
Posted: Tuesday, April 03, 2007 2:13 PM (GST)

Hi, I'm having trouble setting up a subscription for a report. I want to run the report on the first day of every month, with the start date parameter being the first day of the previous month.

Is this possible?

Thanks

Comments:

Author Thread:

joanna

Subscription parameter
Posted: Tuesday, April 03, 2007 3:10 PM (GST)

Yes, it is possible. All you have to do is to set default value for your paramater (so that it is always set to the first day of the previous month) and while creating subscription mark that report has to use default value.

Hope this helps,

Joanna

Dangermouse

Subscription parameter
Posted: Tuesday, April 03, 2007 4:41 PM (GST)

Thats brilliant, thanks Joanna.