February 25, 2014

SQL Server Reporting Service Subscription (Report Automation using Windows File Share)

For the report automation, the report can be delivered using two options:
1) Windows File Share
2) Email Subscription

Here, we will discuss using Windows File Share.

In the file name, it can be edited and make whatever is needed. Here, if you added after the file name @timestamp then after dumping the file you will be able to see date and time when the file was dumped.

The path where the reports are dumped must be provided in UNC (Uniform Naming Convention) format. It is \\\ .

Credentials to access the file share must be provided.

The Render format must be selected as needed.

Schedule the report as needed by clicking Select Schedule.

Parameter must be passed as required.

No comments: