Exporting a Section

After processing a query, you can export the data contents of the Results, Pivot, Chart, Table, or Report sections for use in other applications. If you export from a Results section, the data is raw and unaggregated. If you export from a report section, the data is already aggregated.

In addition, you can export the contents of a Dashboard section to a JPEG file.

  To export the current section to a file:

  1. Select File, then Export, and then Section.

    The Export Section dialog box is displayed.

  2. Specify the location where you want to save the file.

  3. Type a name for the section to be exported in the File Name field.

  4. Select a file format from the Save As Type drop-down list. Select from:

    • Microsoft Office 2000 HTML (*.html)

    • Microsoft Office Web Archive (*.mhtml)

    • Excel (*.xls)

    • Excel 2007 (*.xlsx)

    • Lotus 1-2-3 (*.wks)

    • Text (Tab delimited) (*.txt)

    • Text (Comma Delimited) (*.csv)

    • HTML (*.htm)

    • PDF (*.pdf)

      The available export file formats change depending on which section you export.

      Note:

      Select Format, then Export Properties to set properties for files exported to text or HTML.

      Note:

      You cannot export Report sections using the Excel 2007 format (*.xlsx).

Notes on Exporting a Section to PDF

By default, headers and footers of the Results, Table, Pivot and Chart sections are mapped to the dialog box font, MS Sans. Because this font is not presented as a single file in the system, but as a series of fonts that may be used to show specific charters, the PDFLib can export only a certain amount of characters using the export mechanism for multiple page PDF export. To avoid the lack of double byte characters in the PDF export, change the header and footer font to Arial Unicode MS or Andale WT.

In a Pivot report exported to PDF using the Portrait setting, the total side label width may truncate. To remedy this issue, reduce the number of side labels to decrease the width, or change the page setup to Landscape, and then export the report again.