...
This document provides a documentation how to install and use the Universal Tasks Task for SQL Server Reporting Services.
The here described Universal Task described here calls a script to deploy a report on the Reporting Services Webserver.
This Universal Task is based on the SQL Server Reporting Services RS.EXE utility. RS.EXE is a command line utility that can perform many
scripted operations related to SQL Server Reporting Services (SSRS). It can be used to complete various administrative tasks including
publishing reports and moving reports from one server to another server. The RS.exe utility requires an input file to tell the RS.EXE
"what to do". The list of actual tasks that can be performed is includes among others:
- Deploying / Publishing reports
- Moving reports
- Exporting reports to a file
- Adjust security
- Cancel a running job
- Configure SSRS system properties
The here described Universal Task described here calls a script to deploy a report (#1 in the list above). Points 2-6 in the list above can also be implemented via a script called by the Universal taskTask.
Software Requirements
Software Requirements for Universal Agent
...
This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true. For more information about Resolvable Credentials click here.
Download the provided ZIP file e.g. from the Stonebranch Integration hub.
In the Universal Controller UI, select Administration >Configuration > Universal Templates to display the current list of Universal Templates.
Click Import Template.
Select the template ZIP file and Import.
...
Configure a new Report using Report Builder in SQLSERVER 2016
The following screenshot show shows the MS Report Builder home screen.
...
The report configuration is written to the file system as *rdl file. For example, rechnunsdatenrechnungsdaten.rdl
Test the Report in Report Builder in SQLSERVER 2016
...
Configure the Universal Task to deploy a Report to the Reporting Server.
The
...
Universal Task parameters are described in the following table.
| Parameter | Description |
|---|---|
| REPORTNAME | The actual name of the report (=report file) to be deployed. |
| REPORTSERVER_FOLDER | The folder where the file should be deployed to (reportingserver webfolder). |
| FILEPATH | The location of the rdl file. |
Verify job execution in SAP Data Service Management Console
...
Browse to the folder, where the report should be deployed (see Universal Task Parameter : REPORTSERVER_FOLDER): . For example, /myreports.
