How do I setup Single Report Schedule for SSRS in SQL-RD?

The Single Schedule is the simplest and easiest way to schedule a SSRS report for delivery.

Single Reports Schedule for SSRS.

The Single Schedule is the simplest and easiest way to schedule a report for delivery. It involves defining the report you wish to schedule, determine its timing, selecting parameters (if any), and setting the destination (s) of the report.

Example: Jamie is a reports developer that must send a daily report to management detailing the number of support tickets currently open. She requires a report to be sent in PDF format at 8:30AM to three individuals.

How to Create a Single Schedule Report for SSRS?

  • Go to Single.

SSRS. SQL-RD Home Main Menu.

 

SSRS. General Wizard in Single Report Schedule using SQL-RD.

General Wizard

  • Create In: This section is for select the folder where you want to create the single report in.
  • Use SSRS Account: Select the SSRS Account where your report server is located and the Report Server Browser will appear.
Hint: SQL Azure Reporting Services- when writing your report, make sure you have enabled Forms Authentication. You should use the 2010 .asmx address for your reporting service URL.

SSRS. Report Server Browser in SQL-RD.

  • Report Service URL: Uncheck 'Use SSR Accounts' to enter the address of your reporting services server and click (...) button next to Report Location.
  • Report Location: Browse through the report server browser to select the desired report. Authenticate to the reports server if necessary.
Hint: SQL Azure Reporting Services- when writing your report, make sure you have enabled Forms Authentication. You should use the 2010 .asmx address for your reporting service URL.
  • Schedule Name: Write in the name of the package.
  • Description (optional): you may write a short description to help other users identify exactly what this schedule is and what it is expected to do.
  • Keyword (optional): Enter some keywords which can be used later by Smart Folders to identify this schedule.

Click Next to continue to the next wizard section.

Schedule Wizard

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

In this section, you will decide when the report will execute. There are a variety of options:

  • Daily: Run a report every day or at a frequency of days.
    • Sub options: Repeat every X Days.
Example: Run the schedule every 3 days.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Weekly: Run a report on a weekly time frame.
    • Sub options: Repeat every X weeks.
Example: Run the schedule every 2 Weeks.
  • On: Select the specific days of the week the schedule will run. If only once a week,select only the day of the week it will run.
Example: Run every Monday, Wednesday, and Friday.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Week Days: Run the schedule Monday through Friday.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Working Day: Run the schedule starting on a specific day of the month. Indicate which day of the month the schedule will run. E.G. run the schedule on the 4th working day of the month.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Monthly: Run the schedule on a monthly time frame.
    • Use the following options: Checking this box will enable you to select frequency options such as the “last Thursday of the month.” Also you can include or exclude specific months from the schedule.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Annual: Run the schedule every year at a specified time.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Custom Calendar: Select the custom Calendar you wish to use. You can create a new custom calendar from the menu as well. Please see Custom Calendars for more information.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Other: Other scheduling options.
    • Run Schedule every X Minutes, hours, days, weeks, months, years.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • None:No scheduling is required for this item.

SSRS. Schedule Wizard in Single Report Schedule using SQL-RD.

  • Start Date: Enter the desired starting date for the schedule. This section can be the current date (providing schedule time has not already passed) or a date in the future.
  • End Date: If the schedule is due to end after a certain date enter that here. If the schedule is to run indefinitely, then leave it blank.
  • Schedule time: On the Next Run date, the package will run at this time.
  • Exception Calendar: Choose a calendar that will instruct the schedule to NOT run on those specified days. Please see Custom Calendars for more information.
  • Next to run on: The package will next run on this date.
  • Repeat Every: Rerun the package every x minutes from the scheduled time until your specified time.
For example, you can set up a daily package to run every day at 8 am, and to run every hour until 5 pm.
  • Until: After this date, there will be no automated scheduling of this package.
  • Enable this Schedule: Uncheck this option to Disable the package. Disabled packages are not deleted, but they do not execute automatically. You can re-start the automatic scheduling at a later date by checking this option again. Or right-clicking this schedule from the main screen and selecting Enable.

Click Next to continue to the next wizard section.

Datasources Wizard

SSRS. Datasources Wizard in Single Report Schedule using SQL-RD.

  • In this section you will authenticate to the database the report runs against, set snapshots, and other options.
  • Login Required: Set the authentication information for the report.

SSRS. Datasources Wizard in Single Report Schedule using SQL-RD.

  • Enable Snapshots and keep snapshot for X Days: Save a Picture of the report as it is produced. Choose the amount of time will be stored in the system before deletion.
  • Preview: View the report prior to execution.

Click Next to continue to the next wizard section.

Report Wizard

SSRS. Report Parameters Wizard in Single Report Schedule using SQL-RD.

  • In this section, you will determine the parameters for your report (if any). If your report has no parameters, you may skip this section by clicking next.
  • There are 3 requirements in order for SQL-RD to detect your SSRS Report parameters and their parameter values:
    • The parameter must be in use in the report.
    • The parameter must be visible.
    • The parameter must be set to be prompted at run time.
  • If these three requirements are achieved, you should see the parameters in your report listed in this screen.
  • For each parameter, select from the drop down list the value the report must use. In a single schedule, only one parameter value can be run at a time per parameter. You can type a value into the field, or drag and drop an "insert".

SSRS. Report Parameters Wizard in Single Report Schedule using SQL-RD.

  • SQL-RD can handle SSRS Reports with Cascading parameters, or reports where you can select multiple parameter values.
  • Select All: Selecting All Available Values will run the report given all the values.
  • Specified Value: Select the value you want in your report.
  • Null Value: Set no value for this parameter.
  • Default Value: It will select the default value.
  • All Values (at run time): Any new values will automatically will be included at run time.
Tip: If you are looking to Dynamically populate parameter values, the better choice is Dynamic or Data-Driven Schedule.

Destination Wizard

In this section, you will decide where your schedule will be delivered. The list in the center will display the list of destinations you have added to the schedule. You can organize the various destinations’ order by clicking on the green up and down arrows.

SSRS. Destination Wizard in Single Report Schedule using SQL-RD.

  • Add: Click here to add a destination. You have several options which are: Email, Disk, Fax, Slack, Google Drive, Google Sheets, FTP, ODBC, Printer, Sharepoint, SMS, and Dropbox.

SSRS. Destination Wizard in Single Report Schedule using SQL-RD.

  • Edit: Select a destination and click to edit it's properties. Or simply double-click on the destination.
  • Delete: Select a destination and click this button to delete it.
  • Import: click here to import from the list of default destinations.
  • For more information about Type of Destinations, click here.
  • For more information about Output Formats, click here.

Click Next to continue to the next wizard section.

Exception Handling Wizard

SSRS. Exception Handling Wizard in Single Report Schedule using SQL-RD.

  • Treat as “error” if not completed in X minutes: If a report takes longer than the specified amount of time to run, this option will treat the schedule as an error and follow the appropriate action. The “Auto-calculate” option instructs SQL-RD automatically determine how long a schedule should take to run the report. If it takes longer than the calculated amount of time, then it is an error.
If manually determining the error timing, please double check the run time of the report in order to get the correct time estimate.
  • On error, retry executing schedule every: If set to 0, SQL-RD will deem the schedule as "Failed" the first time it encounters an error. The schedule will not run again until its next scheduled time. Change the value to tell SQL-RD how many times you want it to retry running the report before declaring it as "Failed."
  • Check if the Report is Blank: If a report is blank because it genuinely returned no data, recipients can misconstrue this as an error with the scheduler. This option allows you to identify genuine empty reports and instruct SQL-RD on what to do with them.
  • Ignore the report and subsequent tasks: if the report is blank, do not send the report. The report will not be delivered to the destination. No custom tasks will be run.

Method

SSRS. Exception Handling Wizard in Single Report Schedule using SQL-RD.

  • Select the Method that will determine whether a report is blank.
  • SQL Query: Select this option to use a user made query that will determine if the report is blank. If the query returns no results, the report is blank.
    • Click Build.
    • Get values from a database window will appear. For more information about Get values from database, click here.

SSRS. Get Values from Database interface in SQL-RD

  • File size check: Assume reports is blank if size is under "X" bytes.

SSRS. Exception Handling Wizard in Single Report Schedule using SQL-RD.

Actions

SSRS. Exception Handling Wizard in Single Report Schedule using SQL-RD.

  • Select an action from the task list. This task will be executed in the event that a schedule is blank.
  • For more information about tasks, click here.
Tip: You can send a notification if a report is considered blank instead of sending the report. Simply select “check if a report is blank” then select “Ignore the report.” In the actions tab, select “Send Email” from the list. Compose your email and save.

Click Next to continue to the next wizard section.

Custom Tasks Wizard

SSRS. Custom Tasks Wizard in Single Report Schedule using SQL-RD.

  • In the section you have the option of setting up custom tasks. Custom tasks are business process automation tools that can be auto triggered before or after a report runs.
  • For more information on Custom Tasks, click here.
  • If you have no desire to add a Custom Task, you can click finish to complete the schedule.

Single Report Schedule Context Menu

SSRS. Single Report Schedule Context Menu in SQL-RD

  • Right-Click on a schedule to see the following actions:
    • Properties: Edit the schedule from here. Or you can just double click on the schedule.
    • Copy: Use this to copy the schedule. Right-click in the "white space" of the folder you wish to copy it to and select Paste button.
    • Rename: Rename the package.
    • Enabled: Schedules are enabled when there is a check icon beside this option. To stop a schedule from running, or to "pause" it for a while, select this option to remove the check icon. Disabled schedules will not run until they are enabled again.
    • Move: Use this option to move the report into an existing package.
    • Preview: Preview the report before execution.
    • Execute: This button will execute the schedule immediately. Note that the next run date and time is not moved on as a result of a manual execution. They only move on if the schedule is run automatically by one of the schedulers
    • Delete: Selecting this option will delete the schedule.
    • Test: Use this option to test the schedule and export it to selected "test" destinations.
    • Convert To Package: This button will move this report into a package. The package will have the name of the single schedule report.
    • Ad-Hoc Email to Recipients: Select this option to send an ad-hoc email to all recipients of this package. You can use this to alert recipients to a planned system outage, or any other useful information.
    • Create Shortcut: Use this option to create a shortcut you can save in any location on your PC. Execute the shortcut to execute the schedule in SQL-RD.
    • Ad-Hoc View: This button allows you to preview the report.

Single Report Schedule Properties

SSRS. Single Report Schedule Context Menu in SQL-RD.

  • To access your schedule properties, right click on a schedule and select properties.
  • Similar to the schedule wizard, you adjust settings to your schedule such as timing, error handling, or custom tasks.
  • General

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Schedule

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Report Options

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Report

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Destinations

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Exception Handling

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Tasks

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • Snapshots: A snapshot is a copy of each report a schedule or a package generates. Keeping snapshots enables you to resend past reports without generating them afresh - especially if the data has changed in the meantime.
    • Simply select the number of days to keep the snapshots.

SSRS. Single Report Schedule Properties Wizard in SQL-RD

  • History: Review the schedules history. Successes, failures, and other data is located here.

SSRS. Single Report Schedule Properties Wizard in SQL-RD