Output File Formats

In this section:

Each type of output file supports specific format types. For details, see SAVE File Formats and HOLD File Formats.


Top of page

x
SAVE 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.

.pdf

Styled

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.

.pdf

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:

  • Absolute positioning. DHTML precisely places text and images inside an HTML report, allowing you to use the same StyleSheet syntax to lay out HTML as you use for PDF or PS output.
  • On demand paging. On demand paging is available with SET HTMLARCHIVE=OFF.
  • PDF StyleSheet features. For example, the following features are supported: grids, background colors, OVER, bursting, coordinated compound reports.

.fmp

Styled

LOTUS

Comma-delimited text file for Lotus 123.

.csv

Unstyled

VISDIS

Tab delimited file for Visual Discovery.

.txt

Unstyled



x
HOLD File Formats

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.

.pdf

Styled

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.

.pdf

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:

  • Absolute positioning. DHTML precisely places text and images inside an HTML report, allowing you to use the same StyleSheet syntax to lay out HTML as you use for PDF or PS output.
  • On demand paging. On demand paging is available with SET HTMLARCHIVE=OFF.
  • PDF StyleSheet features. For example, the following features are supported: grids, background colors, OVER, bursting, coordinated compound reports.

.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



x
PCHOLD File Formats

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.

.pdf

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.

.pdf

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:

  • Absolute positioning. DHTML precisely places text and images inside an HTML report, allowing you to use the same StyleSheet syntax to lay out HTML as you use for PDF or PS output.
  • On demand paging. On demand paging is available with SET HTMLARCHIVE=OFF.
  • PDF StyleSheet features. For example, the following features are supported: grids, background colors, OVER, bursting, coordinated compound reports.

.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