Follow-On Topics

Related Topics

# About Output Formats (local Mode Only)

Click the image to view full size.

The Output Formats dialog box is displayed when the Output Formats button is selected either in the Local Mode tab of the Global Configuration dialog box or in the Advanced tab of the Connection Properties dialog box.

When a Run Microsoft Reporting Services Step is run within the Task, by default it provides outputs in a number of different formats, shown in the table below, which are then made available via the Task Browser dialog box to be utilised in other Task Steps.

Output Name | Output Type | Content Type
--- | --- | ---
ExcelOutput | Excel (`.xls`) | application/vnd.msexcel
PrintOutput | IMAGE | IMAGE
EXCELOPENXMLOutput | EXCELOPENXML (`.xlsx`) | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
IMAGEOutput | IMAGE | image/tiff
PDFOutput | PDF | application/pdf
WORDOutput | WORD (`.doc`) | application/msword
WORDOPENXMLOutput | WORDOPENXML (`.docx`) | application/vnd.openxmlformats-officedocument.wordprocessingml.document

To provide complete flexibility, the user may specify additional custom output formats of the Step and the Reporting Services properties that define them and the content type of any of the Steps output formats.

The Output Formats dialog box contains the following:

- Show Output Type — Displays a list of available output types for selection. All outputs of the selected type are then displayed in the table. An All option is also provided to display all types in the table.
- Output Formats — Displays all available output formats, based on the content type selected in the drop down list. The table displays the columns as shown in the table above.

- Duplicate — Clicking on the button duplicates the row selected in the table and adds a suffix number to the Output Format Name. In the example table shown below, the XMLOutput row is duplicated twice which has added two rows with suffix numbers (1) and (2).

  Output Format Name | Output Type | Properties
  --- | --- | ---
  XMLOutput | XML |
  XMLOutput (1) | XML | Custom
  XMLOutput (2) | XML | Custom

- Add — Clicking on this button opens the Output Format Properties dialog box through which a new output format may be created and then properties added to it.
- Edit — Clicking on this button opens the Output Format Properties dialog box to display the details for the output format selected in the table. Note that only the Content Type value may be edited for a default output format and you cannot add, edit or remove any properties associated with it.
- Remove — Removes custom output formats from the table.

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