Extracting Your Report Data

Use the Extract Data command from the File menu to extract your report in other formats.

You can set options associated with each output type by using the Report Properties dialog. For details, see "Using the Output Sheet" under "Setting Report Properties", in Chapter 4.

In addition, you can extract all view, folder, user, system option, report definitions, and template definitions to a single flat file. For details, see "Unloading All Report Writer Data to a Single File", in Chapter 3.

The available output formats are listed in the following table.

Output Format Provides… For details, see…
HTML (HyperText Markup Language) Standard HTML format for displaying the Extracting to an HTML File report on the World Wide Web
File (Delimiter Separated Data) Contiguous file with field delimiters Extracting to a Delimiter‑Separated Data File
Text (ASCII, optionally paginated) Standard ASCII text file Extracting to a Text File
RTF (Rich Text Format) Standard RTF format Extracting to an RTF File
XML (Extensible Markup Language) Standard XML format Extracting to an XML File

To extract your report data

  1. Select the Extract Data command from the File menu.

    The Report Parameters dialog, shown in the following image, is then displayed.

  2. In the Enter Report Parameter Values group box, specify any parameter values used in your report. Enter or select the parameter value for the listed parameter in the Parameter Value column.

    You can specify object parameters in the relevant combo box only when the appropriate JADE methods are reimplemented in the schema from which your JADE Report Writer application is run. If objects are not listed for selection, consult your application developer.

    In the Ignore column, check the check box for the appropriate parameter to specify that the parameter is ignored in selection. This overrides the User value must be entered option on the Param sheet of the Catalog of Available fields dialog, and the Parameter Value must be entered for <parameter name> message box is not displayed when a parameter value is not entered

    Any selection criteria using this parameter are dropped from the query when the report data is extracted. The specified parameter is therefore treated as an all action when applied as a selection criterion.

  3. In the Extract output format group box, select an extract output format by clicking the appropriate option button.

  4. In the Output file Name text box, enter the name and location of the file to which you want to extract.

    If you are unsure of your file name or location, click the Browse button. The common File dialog is then displayed, to enable you to select the appropriate file.

  5. To specify that the output file path and file name specified in the Output file name text box is specified from the perspective of the local (client) workstation, check the Use Client File System check box. If you do not check this box, the output file path and file name is treated as specified from the perspective of the application server. By default, the output file uses the file system of the client workstation.

    The application server executes JADE application logic in JADE thin client mode. It communicates with the JADE database on the server node and one or many presentation (thin) clients; that is, local client workstations.

  6. Click the OK button. Alternatively, click the Cancel button to abandon your selections and close the dialog.

Your current report is then extracted to the specified file.

The JADE Report Writer extract formats are described in the following subsections.