SQL Reporting Services

The SQL Reporting Services Service Type exposes the Export methods for reports published to a SQL Server Reporting Services (SSRS) server, as SmartObject methods. This is commonly used to export SSRS reports as .pdf, image, or Excel files, and then attach the resulting file to an e-mail or upload it to a SharePoint library.

Service Authentication

The following Authentication Modes may be used with the Service Type:

Service Keys (Service Instance Configuration Settings)

Key Can be modified Data Type Sample Value Notes
Timeout Yes Number 30 Seconds to wait before a service method times out.
Reporting Service 2005 URL Yes Text http://localhost/ReportServer/ReportService2005.asmx Enter the Reporting Service URL.
Report Execution Service Yes Text http://localhost/ReportServer/ReportExecution2005.asmx

Enter the Reporting Execution Service URL.

Service Objects

The SQL Reporting Services Instance typically exposes multiple Service Objects for the reports discovered in the targeted SSRS server, grouping the reports into Categories that reflect the Folder structure on the SSRS server.

SmartObjects

SmartObjects can be automatically created by selecting the Generate SmartObjects for this Service Instance check box when creating a new Service Instance. Designers can use the SmartObject design tools to build advanced SmartObjects that leverage the Service Objects in this service. It is recommended to use the SmartObject design tools to create SmartObjects rather than generating SmartObjects, since this allows better control over the naming, behavior and design of the SmartObject and its methods and properties.

Considerations