You can choose from several different formats when you create a styled report. Some formats are designed to be used with specific applications; in order to be used with those applications, they must be transferred to a PC using FTP. For example, you can choose:

• HTML format. You can display your report as an HTML page, which is optimized for display in a Web browser. HTML supports most style sheet options, especially when used with an internal cascading style sheet. An HTML report opens in your Web browser.

  Note: SET STYLMODE=FIXED turns off your browser(tm)s HTML formatting for that report. The resulting report appears in a fixed font without colors and other Web capabilities.

• Print format-PDF (the Adobe® Acrobat® Portable Document Format) and PostScript (PS).

  You can display your report as a PDF document, which is useful when you want the report to look the same whether displayed on screen or in print. PDF (Adobe Acrobat's Portable Document Format) is most often used to distribute and share electronic documents using the web. It is especially useful if you want a report to maintain its presentation and layout regardless of a user's browser or printer type. PDF prints and displays a document consistently, regardless of the application software, hardware, and operating system used to create or display the document. The report opens in Adobe® Acrobat® or Acrobat Reader. To display a PDF report, a computer must have Adobe Acrobat Reader installed. For free downloads of Acrobat Reader, go to http://www.adobe.com.

  Limit: Adobe Acrobat's PDF format limits the number of pages, hyperlinks, and images in a document. For information about what limits this creates for a FOCUS report in PDF format, see Saving and Reusing Your Report Output.

  You can display your report as a PostScript (PS) document, which is a print-oriented page description language most often used to send a report directly to a printer. While used less frequently as an online display format, you can display PS report output on your monitor before printing it.

  To display rather than print a PostScript report, a computer must have a third-party PostScript application installed, such as GSview (a graphical interface for Ghostscript).

  If you are sending a PS report to a printer, you can select the size of the paper on which to print the output. The PostScript code that is generated works on PS printers that support Language Level 2 or above. It is ignored, without harmful effects, on Level 1 printers.

  You can also select page orientation and choose among a wide range of paper sizes and combine several reports into one. PDF and PostScript reports require font metric files and font map files to be accessible to FOCUS. FOCUS comes with a set of basic fonts, and you can add other fonts as needed. For details on working with PDF and PostScript reports, see Using Print Display Formats: PDF, PS.

• Spreadsheet formats. You can display your report as an Excel 2000 or 97 spreadsheet, where you can work with the data in Excel. You can create Excel 2000 HTML-based format (with variations for Excel 2000 PivotTable and Excel 2000 FORMULA), or Excel 97 HTML-based format. Note that Excel 97 format produces the same report output as HTML format. It is useful if you want your Web browser to open the file in Excel rather than display it as an HTML page. These formats supply the following tools:
  • Excel 2000 Worksheet (format EXL2K). The Excel 2000 format supports most StyleSheet attributes, allowing for full report formatting. The computer on which the report is being displayed must have Microsoft Excel 2000 or higher installed.

    In addition, FOCUS supports two Excel 2000 variations: EXL2K FORMULA and EXL2K PIVOT. When either of these formats is specified, additional processing is done. For information on using these options, see Using Excel Display Formats: XLSX, EXL2K, EXL97, EXCEL.

  • Excel 2000 FORMULA (EXL2K FORMULA). If you display a report using the format variation EXL2K FORMULA, the resulting spreadsheet will contain Excel formulas that calculate and display the results of any type of summed information (such as column totals, row totals, and sub-totals).
  • Excel 2000 PivotTable (format EXL2K PIVOT). Generates a fully functional Excel PivotTable, an Excel tool for analyzing complex data.
  • Excel 97 spreadsheet (format EXL97). Excel 97 is an HTML-based display format that opens in Excel 97 or higher and supports report formatting. The computer on which the report is being displayed must have Microsoft Excel 97 or higher installed.