Working with output formats
By default, running a BIRT design (.rptdesign) file generates a BIRT document (.rptdocument) file. When scheduling a BIRT design job using basic and advanced scheduling options, in Document format, you can specify any of the output formats shown in Figure 3‑8.
Figure 3‑8 Specifying an optional output format for a BIRT design
When you use advanced scheduling to schedule a design, and basic or advanced scheduling to schedule a document, Output displays additional flat file formats such as comma‑separated, pipe-separated, and tab-separated value (CSV, PSV, or TSV) formats that you can select, as shown in Figure 3‑9.
Figure 3‑9 Specifying an output format to which to convert a BIRT document
You can view and read output files in these formats either using a text editor such as Microsoft Notepad or using Microsoft Excel. Table 3‑10 describes the options available for CSV, PSV, or TSV flat file output formats.
Table 3‑10 Supported options when exporting data to flat file formats
Table name
Selects the name of the data set, which the design uses, from the list of all data sets in the data source.
Column list
Selects the name of the column, which the design includes in the result, from the names of all columns in the data set.
Export columns data type
Adds information about the column’s data type to the second row of the output file.
Locale neutral format
Formats date‑and‑time values according to ISO 8601 standards as YYYY-MM-DD and HH‑MM‑SS using the 24‑hour clock. It includes an offset from UTC time.
Sets either UTF-16LE or UTF-8 encoding of the output data.
Maximum rows
Sets the maximum number of rows displayed in the output file.