SQL Server Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) is Microsoft’s server-based reporting platform that includes a variety of tools to help you create, manage, and deliver reports throughout your organization. With Reporting Services, you can define interactive, tabular, or free-form reports from relational, multidimensional, or XML-based data sources. In addition, you can publish, access, and schedule reports on-demand.

Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools.

These reporting services also enable developers to integrate or to extend data and report processing using custom applications, such as JAMS.

Scheduling SSRS within JAMS

SQL Server Reporting Services can be natively scheduled within JAMS by using the built-in SSRS Execution Method.

NOTE: When using the SSRS Execution Method, the Source of the Job is used to save reports to a physical location. The Send a report as an e-mail Schedule Item may be used to email the saved report. To email the report, you must have an SMTP Server configured, and the user running the SSRS Job must have access to the network location where they want to save the report.

Creating a JAMS Job using the SSRS Execution Method

You must first define a Job that can work with SSRS. This is done by creating a JAMS Job using the SSRS Execution Method and then setting up a JAMS Report for that Job.

  1. Click Definitions from the Shortcuts menu.
  2. Select the desired folder for the SSRS Job, and then ensure the Job Definitions tab is selected.
  3. Click Add.
  4. In the Name field, enter a name for the new Job.
  5. In the Execution Method field, select SSRS.
  6. Ensure the Edit this job definition after adding checkbox is selected.
  7. Click Ok.
  8. Select the Source tab.
  9. In the Report Server field, enter the address for the SQL reporting server . Once the Report Server is properly specified, all accessible reports will display in the Report Path drop-down property. Select the desired report from the drop-down list.
  10. Set the Authentication Method JAMS will use when logging onto the server and, if applicable, the logon Credential.
  11. In the Report Format field, select a format from the drop-down list.
  12. In the Report Location field, specify where a copy of the report will be saved.
  13. In the Report Title field, enter the title for the saved report.
  14. Configure additional Schedule, Security, Properties, and Documentation as desired.
  15. If the saved SSRS report should be e-mailed, see the Send a Report as an Email section in Reports.
    NOTE: Only SMTP is supported when sending emails with SSRS Jobs. See Connections to Mail Servers for more information.
  16. Click Save and Close.

Related Topics