In this section: |
Each type of output file supports specific format types. For details, see SAVE File Formats and HOLD File Formats.
The following is a list of file formats available for SAVE files from Report Painter.
Administrators and developers can request all formats by issuing the appropriate WebFOCUS command from the Command Console or by creating a procedure in the Text Editor.
File Format |
Output |
Extension |
Report Format |
---|---|---|---|
ALPHA |
Saves report data in character (ASCII) format. Alpha is the default value. |
.ftm |
Unstyled |
COMMA |
Saves all the columns of the report request and creates a CSV (Comma Separated Values) file. Alphanumeric fields are enclosed in quotation marks. Columns are separated by commas. |
.prn |
Unstyled |
COMT |
Comma-delimited text file with field names. |
.csv |
Unstyled |
DIF |
Saves the entire report, including the report data, column headings, footings, and subtotals, and creates a DIF (Data Interchange Format) file that can be easily imported into most spreadsheet packages. |
.dif |
Unstyled |
DOC |
Captures the entire report output, including headings, footings, and subtotals, and creates a text file that can be easily incorporated into most word processing packages. DOC format uses an ASCII form-feed character to indicate page control information. |
.doc |
Unstyled |
EXCEL |
Saves the report output as a Microsoft Excel 95 worksheet. |
.xls |
Unstyled |
HTML |
Creates an output file that contains an HTML document. For more information, see Saving Reports as HTML Output. |
.htm |
Styled |
HTMLTABLE |
HTML Table. |
.html |
Styled |
AHTML |
An HTML active report is a report that is designed for offline analysis. For more information, see Using an Active Technologies Report in the Active Technologies User's Guide. |
.htm |
Styled |
FLEX |
The active report for Adobe Flash Player includes most of the capabilities available in the HTML version of active reports delivered as a self-contained Adobe® Flash® Player compatible file (.swf). For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide. |
.swf |
Styled |
APDF |
Using Active Technologies for Adobe Flash Player in PDF provides the ability to include interactive Flash® based reports, dashboards, and animations in PDF documents. For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide.
|
|
Styled |
|
Saves the report output in Adobe Portable Document Format, which allows precise placement of output (all formatting options) on the printed page so the report looks exactly as it would when printed. For more information on PDF files, see Saving Reports as Print Display Output: PDF, PS. |
|
Styled |
WP |
Saves the entire report output, including titles, headings, and footings, and creates a text file (with IBM OEM codes) that can be easily incorporated into most word processing packages. Text with layout, without linebreaks. |
.wp |
Unstyled |
&WFFMT |
User (Variable output). |
.html, .xht, .pdf |
Styled |
EXL2K |
Generates fully styled reports in Excel 2000 HTML format. Requires Excel 2000 on your PC. For details, see Saving Reports Using Excel Formats. |
.xht |
Styled |
EXL07 |
Generates fully styled reports in Excel 2007. Requires Excel 2007 on your PC. For details, see Saving Reports Using Excel Formats.
|
.xht |
Styled |
EXL2K FORMULA |
Excel 2000 with formulas. |
.xht |
Styled |
EXL2K PIVOT |
Generates fully styled reports in Excel 2000 HTML format, with added pivoting capabilities. Requires Excel 2000 on your PC. For details, see Saving Reports Using Excel Formats. |
.xht |
Styled |
EXL97 |
Excel 97. |
.xls |
Styled |
PS |
PostScript. |
.ps |
Styled |
DHTML |
Provides HTML output that has most of the features normally associated with output formatted for printing such as PDF or PostScript output. You can create an HTML file (.htm) or a Web Archive file (.mht). The type of output file produced is controlled by the value of the HTMLARCHIVE parameter. HTMLARCHIVE=ON creates a Web Archive file. Some of the features supported by format DHTML are:
|
.fmp |
Styled |
LOTUS |
Comma-delimited text file for Lotus 123. |
.csv |
Unstyled |
VISDIS |
Tab delimited file for Visual Discovery. |
.txt |
Unstyled |
The following is a list of file formats available for Hold files.
These formats are supported in the WebFOCUS language and in Report Painter (RP).
File Format |
Output |
Extension |
Report Format |
---|---|---|---|
ALPHA |
Saves the report output as MS-DOS text data. It also creates a Master File. |
.ftm |
Unstyled |
BINARY |
Saves the report data and stores numeric fields as internal binary numbers and also creates a Master File. BINARY is the default format. |
.ftm |
Unstyled |
COMMA |
Saves all the columns of the WebFOCUS report request and creates a CSV (Comma Separated Values) file. Alphanumeric fields are enclosed in quotation marks. Columns are separated by commas. |
.prn |
Unstyled |
COMT |
The COMT format saves the column headings in the first row of the output file. It produces a variable-length text file, with fields separated by commas and with character values enclosed in double quotation marks. This is useful for further processing in a database application. This format type can be imported into applications, such as Excel or Lotus. |
.csv |
Unstyled |
DBASE |
Creates an extract file in dBase format that includes column headings in the first row. |
.dbf |
Database |
DB2 |
Captures the report data and creates an IBM DB2 data source table. |
n/a | |
DIF |
Captures the entire report, including the report data, column headings, footings, and subtotals, and creates a DIF (Data Interchange Format) file that can be easily imported into most spreadsheet packages. |
.dif |
Unstyled |
DOC |
Saves the report output as MS-DOS text with layout and line breaks. |
.doc |
Unstyled |
&WFFMT |
User Variable output. |
.html, .xht, .pdf |
Styled |
EXCEL |
Saves the report output as a Microsoft Excel 95 worksheet. |
.xls |
Unstyled |
EXL2K |
Generates fully styled reports in Excel 2000 HTML format. Requires Excel 2000 on your PC. For details, see Saving Reports Using Excel Formats. |
.xht |
Styled |
EXL07 |
Generates fully styled reports in Excel 2007. Requires Excel 2007 on your PC. For details, see Saving Reports Using Excel Formats.
|
.xht |
Styled |
EXL2K FORMULA |
Generates fully styled reports in Excel 2000 HTML format, with added pivoting capabilities. Requires Excel 2000 on your PC. For details, see Saving Reports Using Excel Formats. |
.xht |
Styled |
EXL2K PIVOT |
Generates fully styled reports in Excel 2000 HTML format, with added pivoting capabilities. Requires Excel 2000 on your PC. For details, see Saving Reports Using Excel Formats. |
.xht |
Styled |
EXL97 |
Excel 97. |
.xls |
Styled |
Default |
Captures the report data and creates a FOCUS data source. Note: There is an additional Index Input field on the Output tab of the Report Options dialog box. |
.foc |
Database |
HTML |
Creates an output file that contains an HTML (web) document. For more information, see Saving Reports as HTML Output. |
.htm |
Styled |
HTMTABLE |
Creates an output file that contains an HTML table, not a complete HTML document. For more information, see Saving Reports as HTML Output. |
.htm |
Styled |
AHTML |
An HTML active report is a report that is designed for offline analysis. For more information, see Using an Active Technologies Report in the Active Technologies User's Guide. |
.htm |
Styled |
FLEX |
The active reports using Adobe® Flex® include most of the capabilities available in the HTML version of active reports delivered as a self-contained Adobe® Flash® Player compatible file (.swf). For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide.
|
.swf |
Styled |
APDF |
Using Active Technologies for Adobe Flash Player in PDF provides the ability to include interactive Flash® based reports, dashboards, and animations in PDF documents. For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide.
|
|
Styled |
|
Saves the report output in Adobe Portable Document Format, which allows precise placement of output (all formatting options) on the printed page so the report looks exactly as it would when printed. For more information on PDF files, see Saving Reports as Print Display Output: PDF, PS. |
|
Styled |
PostScript (PS) |
Saves the report as a PostScript document. You must have installed a third party tool capable of displaying PS. See Saving Reports as Print Display Output: PDF, PS. |
.ps |
Styled |
DHTML |
Provides HTML output that has most of the features normally associated with output formatted for printing, such as PDF or PostScript output. You can create an HTML file (.htm) or a Web Archive file (.mht). The type of output file produced is controlled by the value of the HTMLARCHIVE parameter. HTMLARCHIVE=ON creates a Web Archive file. Some of the features supported by format DHTML are:
|
.fmp |
Styled |
DB2 |
DB2 database table. |
n/a |
Database |
SAMEDB |
Creates a report output file as a native DBMS temporary table. This increases performance by keeping the output file on the DBMS server, instead of downloading it to your computer. When SAMEDB is selected, a Persistence option is available on the Report Options Output tab. Select from VOLATILE, GLOBAL_TEMPORARY, and PERMANENT. For more information, see Save Report Output as a Native Temporary Table In Report Painter. |
n/a |
Database |
SQLDBC |
Creates an extract file stored in the Teradata Server. |
n/a |
Database |
SQLINF |
Captures the report data and creates an Informix data source table. |
n/a |
Database |
SQLMAC |
Saves report output as a Microsoft Access database table. |
n/a |
Database |
SQLMSS |
Captures the report data and creates a Microsoft SQL Server data source table. |
n/a |
Database |
SQLSYB |
Captures the report data and creates a Sybase data source table. |
n/a |
Database |
SQLODBC |
Captures the report data and creates a file or data source table using the current ODBC data source driver. |
n/a |
Database |
SQLORA |
Captures the report data and creates an Oracle data source table. |
n/a |
Database |
SQLNEO |
Captures the report data and creates an HP Neoview data source table. |
n/a |
Database |
INGRES |
Ingres database table. |
n/a |
Database |
TAB |
Tab Delimited file. |
.tab |
Unstyled |
TABT |
Tab Delimited text file with field names. |
.tab |
Unstyled |
VISDIS |
Creates a tab-delimited output file in which the first record has the column titles and the second record contains Visual Discovery formats based on the FOCUS field formats of the data. |
.txt |
Unstyled |
LOTUS |
Comma-delimited text file for Lotus 123. |
.csv |
Unstyled |
SYLK |
Microsoft Multiplan spreadsheet. |
Unstyled | |
INTERNAL |
Binary file without padding. |
.ftm |
Unstyled |
XML |
Standard XML. |
.xml |
Unstyled |
WP |
Saves the entire report output, including titles, headings, and footings, and creates an MS-DOS text file (with IBM OEM codes) with no line breaks. This file can be easily incorporated into most word processing packages. |
.wp |
Unstyled |
WK1 |
Captures the report output data and creates a file that can be imported into Lotus 1-2-3, Release 2. |
.wk1 |
Unstyled |
The following is a list of file formats available for PCHOLD files from Report Painter. Several formats support PCHOLD variations for transferring remotely-created output from a host to a local workstation or from a web server to a browser.)
The PCHOLD variations are only supported in Report Painter.
File Format |
Output |
Extension |
Report Format |
---|---|---|---|
PCHOLD ALPHA |
Saves report data in character (ASCII) format. Alpha is the default value. |
.ftm |
Unstyled |
PCHOLD BINARY |
Binary Data file with File Description. |
.ftm |
Unstyled |
PCHOLD COMMA |
Saves all the columns of the report request and creates a CSV (Comma Separated Values) file. Alphanumeric fields are enclosed in quotation marks. Columns are separated by commas. |
.prn |
Unstyled |
PCHOLD DIF |
Saves the entire report, including the report data, column headings, footings, and subtotals, and creates a DIF (Data Interchange Format) file that can be easily imported into most spreadsheet packages. |
.dif |
Unstyled |
PCHOLD DOC |
Captures the entire report output, including headings, footings, and subtotals, and creates a text file that can be easily incorporated into most word processing packages. DOC format uses an ASCII form-feed character to indicate page control information. |
.doc |
Unstyled |
PCHOLD EXCEL |
Saves the report output as a Microsoft Excel 95 worksheet. |
.xls |
Unstyled |
PCHOLD HTML |
Creates an output file that contains an HTML document. For more information, see Saving Reports as HTML Output. |
.htm |
Styled |
PCHOLD HTMLTABLE |
Transfers the data from a web server to a browser. |
.html |
Styled |
PCHOLD AHTML |
The HTML active report is a report that is designed for offline analysis. For more information, see Using an Active Technologies Report in the Active Technologies User's Guide. |
.htm |
Styled |
PCHOLD FLEX |
The active reports using Adobe® Flex® include most of the capabilities available in the HTML version of active reports delivered as a self-contained Adobe® Flash® Player compatible file (.swf). For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide.
|
.swf |
Styled |
PC HOLD APDF |
Using Active Technologies for Adobe Flash Player in PDF provides the ability to include interactive Flash® based reports, dashboards, and animations in PDF documents. For more information, see Active Technologies Report Integration With Adobe Flash Player in the Active Technologies User's Guide. |
|
Styled |
PCHOLD PDF |
Saves the report output in Adobe Portable Document Format, which allows precise placement of output (all formatting options) on the printed page so the report looks exactly as it would when printed. For more information on PDF files, see Saving Reports as Print Display Output: PDF, PS. |
|
Styled |
PCHOLD TAB |
Tab Delimited file. |
.tab |
Unstyled |
PCHOLD TABT |
Tab Delimited text file with field names. |
.tab |
Unstyled. |
PCHOLD WK1 |
Saves report output as a Lotus 1-2-3 worksheet, Release 2. |
.wk1 |
Unstyled |
PC HOLD WP |
Saves the entire report output, including titles, headings, and footings, and creates a text file (with IBM OEM codes) that can be easily incorporated into most word processing packages. |
.wp |
Unstyled |
PC HOLD &WFFMT |
User Variable output. |
.html, .xht, .pdf |
Styled |
PC HOLD EXL2K |
Excel 2000. |
.xls |
Styled |
PC HOLD EXL07 |
Excel 2007.
|
.xls |
Styled |
PCHOLD EXL2K FORMULA |
Excel with formulas. |
.xht |
Styled |
PCHOLD EXL2K PIVOT |
Excel 2000 PivotTable. |
.xht |
Styled |
PCHOLD EXL97 |
Excel 97. |
.xls |
Styled |
PCHOLD PS |
PostScript. |
.ps |
Styled |
PCHOLD DHTML |
Provides HTML output that has most of the features normally associated with output formatted for printing such as PDF or PostScript output. You can create an HTML file (.htm) or a Web Archive file (.mht). The type of output file produced is controlled by the value of the HTMLARCHIVE parameter. HTMLARCHIVE=ON creates a Web Archive file. Some of the features supported by format DHTML are:
|
.fmp |
Styled |
PC HOLD LOTUS |
Comma-delimited text file for Lotus 123. |
.csv |
Unstyled |
PCHOLD XML |
Standard XML. |
.xml |
Unstyled |
PCHOLD VISDIS |
Tab delimited file for Visual Discovery. |
.txt |
Unstyled |
WebFOCUS |