Monday, January 11, 2016

SQL-RD Single and Package schedule

Single Schedule

 Scheduling SSRS reports for singe schedule delivery

Select the report 

   Specify the timing to run the reports
   Ex weekly Week days

Report :
  Specify report parameters

Note: we can specify date and constants

Report Options:
We can set database authentication

  Section determines the destination like Email, Disk, SMS, Printer

 Format :
 We can specify different file format

Exception handling
  If there was an error send email or stop sending reports

 Custom Task:
 Can run before or after the report runs
   Ex: Updating database records ftp drop etc

Sample single schedule reports

Package Schedule

  •  Enables multiple SSRS reports within one schedule
  •  Enables us to batch these multiple reports to a single PDF or Excel

No comments:

Post a Comment