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 hand-in-hand within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools.

These reporting services also enable developers to integrate or 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. An Email Report element may used to Email the saved Report. In order to Email the Report, users 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

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

  1. In the JAMS Client, navigate to the Definitions section.
  2. Select the desired folder for the SSRS Job, then ensure the Job Definitions tab is selected.
  3. Click the Add button from the Control Bar to open the Add a New JAMS Job Definition dialog.
  4. In the dialog, give the new Job a Name, Description (optional), and Execution Method.
    In this case, select SSRS to create an SSRS Job.
  5. By default, the full Job Definition dialog will open when the Job is initially saved. Click OK.
  6. The Job Definition dialog will open. Select the Source tab.   
  7. Enter the address for the SQL reporting server in the Report Server field. Once the Report Server is properly specified, all accessible reports will display in the Report Path dropdown property. Select the desired report from the drop-down list.
  8. With the Report Server and Path specified, set the Authentication Method JAMS will use when logging onto the server and, if applicable, the logon User.
  9. Select a Report Format from the drop-down list.
  10. Specify the Report Location (where a copy of the report will be saved).
  11. Enter the Title for the saved report. 
  12. If the saved SSRS report should be e-mailed, navigate to the Elements tab and click the Add... button.
  13. Expand the Result category, then select Email Report and click Next.
  14. Define the Email Report Properties as desired for the Report. Multiple e-mail addresses may be used in the CC Address and To Address fields by separating them with a comma or semicolon.
  15. When the Email Report element is defined as desired, click Finish.
  16. Configure additional Elements, Properties, and Documentation as desired.
  17. Save and Close the Job.

Related Topics