Reporting – SQL Server

This job step allows you to generate a report based on the SQL Server Reporting facility.

 

 

Platforms Supported

Windows.

 

Software Prerequisites

None.

 

Job Step Properties

 

Report Server – This property represents a SQL Server Reporting Services machine. The actual specification is a URL (HTTP or HTTPS) that contains the hostname and reporting server name.

 

Report – This property is the name/location of the report. Clicking on the dropdown will cause a list of reports on the server to be displayed.

 

Format – This property represents the output format of the report. Clicking on the dropdown causes a series of report formats to be displayed. You must select one format. Depending on the format selected, a series of sub-properties based on the format are shown. In the example above, when PDF is selected, the sub-properties concerning PDF are displayed.

 

OutputFile – This property indicates the file specification for the generated report file.

 

Custom Format Extension – This set of properties allows you to access and specify another formats that have been added as extensions.

 

  • Report Server Config File – This property indicates the location of the SQL Server Reporting configuration file. This file must be accessible to both the Job Scheduler system as well as the Execution Machine.

  • ExtensionName – This dropdown property indicates the format extension you want.

  • AdditionalProperties – Depending on the format extension selected additional properties will be displayed.

 

ReportCredentials – The object path of a User Account object. Clicking on the “Helper” will cause a tree display of all ActiveBatch containers. You may then select a User Account object. The User Account credentials must have proper access to the report server.

 

Timeout – This optional property indicates how long to wait, in seconds, for the SQL Report to be generated. The default is 60 seconds.

 

Parameters – This optional series of properties represents zero or more parameter name/value pairs. To add a parameter, click on the Parameters property. Two (2) buttons will be displayed: Add and Delete. Click the Add button to add a Name and Value. Click Delete to delete an existing parameter.