Follow-On Topics

Related Topics

# Technical Summary

## Working with Other Tools

The other tools that the Run Microsoft Reporting Services tool interacts directly with, whether by exposing information to it or consuming information from it, are listed below.

### Consuming from Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Database Query (ODBC) | Input and Data Connectors
| Database Query (OLEDB) | Input and Data Connectors
| Import Flat File | Input
| Import XML Document | Input
| Convert Recordset to XML | Format
| Convert XML to Recordset | Format
| Transform Data | Format
| Call Task | Execute
| Filter Data | General
| Web Service Connector | Data Connectors
| Applications Platform Connector | Data Connectors

### Exposing to Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Print Document | Output
| Save File | Output
| Send Email (SMTP) | Output
| Transfer File (FTP) | Output
| Call COM Object | Execute
| Run External Program | Execute

## Tool Outputs

The type of output produced by a Run Microsoft Reporting Services step is not set in the tool step. The tool consuming the output determines the type of output produced. The available outputs vary depending on the mode of operation (local or server) and are limited by the consuming tool.

### Print Output

A print output of the report is available in both local and server mode using the Print Document tool.

### Email Output

Report outputs can be delivered using the Send Email (SMTP) tool and the available types differ depending on the mode and whether the output is required as an attachment or in the message body

Output Type | Local Mode | Server Mode
--- | --- | ---
Message Body | Attachment | Message Body | Attachment
ATOM |  |  |  | 
CSV |  |  |  | 
EXCEL |  |  |  | 
EXCEL OPEN XML |  |  |  | 
HTML32 |  |  |  | 
HTML40 |  |  |  | 
HTML5 NOTE: Only available when using SQL Server 2016 with the Microsoft Report Server. |  |  |  NOTE: Only available where the email service supports it. | 
IMAGE |  |  |  | 
MHTML |  |  |  | 
PDF |  |  |  | 
PPTX NOTE: Only available when using SQL Server 2016 with the Microsoft Report Server. |  |  |  | 
RGDI |  |  |  | 
RPL |  |  |  | 
WORD |  |  |  | 
WORD OPEN XML |  |  |  | 
XML |  |  |  | 

### File Outputs

The Save File Tool can be used to save to a local file system and the Transfer File (FTP) tool to save to a remote server. For both tools, in local mode Excel, Image, PDF, Word formats can be output; Excel and Word Open XML formats are additionally available using SQL Server 2012. In server mode all of the above outputs can be saved (from the table above). The Call Stored Procedure (OLEDB) tool can also consume these outputs in these modes.

Copyright © 2018 Quadrant Software B.V. All rights reserved.