Collapse All Expand All

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 (v. 6.3.24 and later), by using the built-in SSRS Execution Method.

 

Creating a JAMS Job using the SSRS Execution Method

Users must first define a Job that can work with SSRS. This is done by first 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 Job Definitions section. If the Job should be added in a particular folder, select that folder.
2. Click the Add button on the Ribbon Bar to access the JAMS Job Definition Wizard.
3. Enter a unique name for the Job, and a description, if desired. Click the Next button.
4. On the Execution Method step, choose the SSRS Execution Method.
   
5. On the Source step, first 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.
   
6. With the Report Server and Path specified, set the Authentication Method JAMS will use when logging onto the server and the logon User, if applicable. Next, select a Report Format from the drop-down list, specify the Report Location (where a copy of the report will be saved), and the Subject of the e-mail that will contain the report.
   NOTE: The report e-mail will be configured in steps 9-10.
   
7. In the next two Job creation wizard steps, set notification and run-as options as desired.
8. Ensure Edit the Job definition after adding option is checked, then click Finish.
   
9. In the Job dialog that opens, navigate to the Reports section of the Properties tab and click the Add... button. This new report will control where the completed report is sent.
   
10. In the Job Report setup dialog that appears, populate the three required fields: Report ID, File Name, and Print Queue. An overview of these fields is available below.
    
11. Save and Close the Job Report setup dialog and the Job dialogs to save the changes to the Job.

Report ID

Enter a unique name for the report to be added to the current Job. This name is not tied to SSRS.

File Name

This property identifies where the output file is saved after the report has been generated. A filename and extension are then generated automatically. If a path is not specified, then no output files are written when the report is generated.

Print Queue

For this property enter only email addresses to send the generated report file. If multiple email addresses are needed, they should be separated by semi-colons or commas.

Once both the File Name and Print Queue properties are specified then the report is saved and emailed to any listed recipients.

 

 

---

Topic updated: 1/26/2017
Copyright © JAMS Software, LLC.
All Rights Reserved.
.