Export Data tab

The Export Data tab allows you to save report data to your computer. You can save the data as a comma separated values (CSV), Excel (XLSX), or portable document format (PDF) file.

Specify one of the following:

  • Comma Separated Values (CSV): Saves the data as a CSV file.
  • Microsoft Excel (XLSX):.Saves the data as an Excel file.
  • Export Range: When you select to save the report as a CSV or XLSX file, the Export Range dialog becomes active allowing you to export the entire report, or just the report rows you selected on the Report tab.
  • Portable Document Format (PDF): Saves the entire report as a PDF file.
  • Include Cover Page: When you export to a PDF file, you can include a cover page that contains a summary of the report information, as shown on the Information tab.
  • Include Filter Details: Check this box to include your Filter configuration on the cover page. See Filters tab.
  • Paper: When exporting to a PDF file, use the Paper dialog to specify the page size and orientation (Portrait or Landscape) to use for the report.

Click the Export button to export the data.

NOTE: Formatting of timestamp and date fields in the .xlsx export can now be controlled. The Powertech Compliance Monitor for IBM i export to .xlsx format currently outputs date fields with dashes as separators (per ISO 8601). If you would like to format these fields differently, Powertech Compliance Monitor for IBM i now provides the mechanism: add the properties EXCEL_TIMESTAMP_FORMAT and/or EXCEL_DATE_FORMAT to format these fields differently. The values of these properties need to be set to a valid format. Examples of these are "yyyy-MM-dd hh.mm.ss" and "yyyy-MM-dd". Replace the dashes with slashes if you want to use slashes as delimiters - "yyyy/MM/dd hh.mm.ss" and "yyyy/MM/dd".