# Export an Analyzer report

You can export a report as a PDF, CSV, or an Excel Workbook file.

1. In the Analyzer toolbar, click **More actions and options** > **Export Report**.
2. Select an output format from the menu. The **Export** dialog box appears.

   If you are exporting to:

   * **PDF**

     Specify how you want the page formatted.
   * **CSV**

     Specify formatting options and the **Separator** character. The default separator is a comma (,).
   * **Excel Workbook**

     Specify how you want the workbook formatted. You can select or clear the **Merge pivot table cells** option.

     * Select this option to keep nested pivot row and column headers grouped together.
     * Clear this option to separate nested pivot headers to individual rows for easier sorting.**Note:** Maps are not supported for export to Excel.
3. After specifying or modifying the export options, select one of the following actions:

| **Done**   | Saves any modifications to the export settings, but does not export.                                                               |
| ---------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| **Export** | Applies the options and generates output. If your report includes a chart, it is included in the report along with the table view. |
| **Cancel** | Discards all changes.                                                                                                              |

4\. \\(Optional\\) If you want it to keep the export settings, you must \*\*Save\*\* the report.

Metadata for report author, source file location, fields used and filter summary are included in the report.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pba/pentaho-analyzer-cp/export-an-analyzer-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.