SQL-RD Single and Package schedule

Single Schedule

 Scheduling SSRS reports for singe schedule delivery


Select the report 

Schedule:
   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

 Destination:

  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