|
How to: |
|
Reference: |
You can choose from among several display formats for your report:
A note about DHTML and HTML: DHTML is the absolute positioning version of HTML. As architected, format HTML generates output in a table-based format that leaves the exact positioning to the browser that is presenting the report. Format DHTML on the other hand is designed to render with the user-defined positioning in the same way as PDF. This means things should position on the page precisely as defined in the report procedure. PDF, DHTML, PPT, PPTX, and PS are position-based. HTML and EXL2K are table or cell based. Therefore, DHTML output looks more like PDF rather than HTML.
For information about which file formats are available for saving and reusing (as opposed to displaying) report data, see Saving and Reusing Your Report Output.
Note: For styled output formats, setting the LINES parameter to 999 or higher generates continuous forms. When continuous forms are specified, but the output format has a physical page size (as is the case with PDF output), the column titles repeat at the top of the physical page, without page numbers.
You can display a report on screen using the ON TABLE PCHOLD command in a report request.
ON TABLE PCHOLD FORMAT formatname
where:
|
DOC |
Specifies that the report will be displayed as a plain-text word processing document, with page breaks, in Microsoft Word within your web browser. See ○k |
|
EXCEL |
Specifies that the report will be displayed as an Excel spreadsheet. See Saving Report Output in Excel XLSX Format. |
|
XLSX |
Specifies that the report will be displayed as an Excel 2007/2010 worksheet. See Saving Report Output in Excel XLSX Format. |
|
EXL2K |
Specifies that the report will be displayed as an Excel 2000/2003 worksheet. |
|
EXL2K FORMULA |
Specifies that the report will be displayed as an Excel 2000/2003 worksheet, with WebFOCUS totals and other calculated values translated to active Excel formulas. (If your report does not contain any formulas, consider using EXL2K format since EXL2K FORMULA requires additional processing time.) |
|
EXL2K PIVOT |
Specifies that the report will be displayed as an Excel 2000/2003 PivotTable. |
|
EXL97 |
Specifies that the report will be displayed as an Excel 97 worksheet. |
|
HTML |
Specifies that the report will be displayed as an HTML page. See Using Web Display Format: HTML. |
|
|
Specifies that the report will be displayed as a PDF document (Adobe Acrobat's Portable Document Format). See Using PDF Display Format. |
|
PostScript
(PS) |
Specifies that the report will be displayed as a PostScript document. You must have installed a third party tool capable of displaying PS. See Using PostScript (PS) Display Format. |
|
WP |
Specifies that the report will be displayed as a plain-text word processing document in the web browser. See Using Word Processing Display Formats: DOC, WP. |
For a limited set of formats, you can display a report on screen using the SET command ONLINE-FMT parameter.
Outside of a report request, use the following syntax to specify a format for all report requests within the procedure
SET ONLINE-FMT = formatname
Within a report request, use the following syntax to specify a format for that request only
ON TABLE SET ONLINE-FMT formatname
where:
|
HTML (default) |
Specifies that the report will be displayed as an HTML page. See Using Web Display Format: HTML. |
|
|
Specifies that the report will be displayed as a PDF document (Adobe Acrobat Portable Document Format). See Using PDF Display Format. |
|
XLSX |
Specifies that the report will be displayed as an Excel 2007/2010 worksheet. See Saving Report Output in Excel XLSX Format. |
|
EXL2K |
Specifies that the report will be displayed as an Excel 2000/2003 worksheet. |
|
EXL97 |
Specifies that the report will be displayed as an Excel 97 worksheet. |
|
PostScript (PS) |
Specifies that the report will be displayed as a PostScript document. You must have installed a third party tool capable of displaying PS. See Using PostScript (PS) Display Format. |
|
STANDARD |
Specifies that the report will be displayed using a legacy character-based and line-based layout and a monospaced font. |
Tip: ONLINE-FMT syntax will be superseded by PCHOLD syntax in future releases of WebFOCUS (see Choose a Display Format Using PCHOLD). At present, they can be used interchangeably.
In addition to creating reports in HTML format for display in a web browser, you can generate reports that can be returned to the browser and opened in a desktop application or in a helper application. In order for the browser to recognize and call the correct desktop application, you must associate the MIME (Multipurpose Internet Mail Extension) type of the report with a specific application.
For details, see the TIBCO WebFOCUS® Developing Reporting Applications manual.