Creating Subscriptions on the SQL Reporting Server 2000


Follow the following steps for creating subscriptions
1. Log into the reporting server: http://crmServer/reports
2. Click on _MSCRM Subscriptions Folder
3. Click on the report for which the subscription needs to be created
4. Click on the Subscriptions Tab
5. Click on New Subscription
6. Under Report Delivery Options, choose ‘Report Server File Share’
7. Provide details for the File Name as mentioned below
8. Provide the path of the folder where you want to save this subscription. This folder should be in the root directory of the reporting server. The person who is creating the subscription should have Read/Write Access to this folder.
For Ex: In the development server, a folder called ‘SubscribedReports’ has been created in the C drive. If a person called DomainName\XYZ’ is creating the subscription, then DomainName\XYZ’ should have write access to the ‘Subscribed Reports’ folder. The path to be provided in the reporting server subscription page would be ‘\\.’
9. Choose the render format : PDF format
10. Provide the Username/Password.
11. Under Subscription Processing Options, click on the button ‘Select Schedule’
12. Choose the scheduling date and time and then click on OK – Scheduling Every Monday at 10.00AM for all the reports
13. Under Report Parameter Values, choose the parameters that would be applicable for the specified subscription.
14. When all of the above have been completed, click on OK.

That’s all

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Creating Subscriptions on the SQL Reporting Server 2000”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.