Query results can be exported to these formats: HTML, PDF, CSV, and XML.
Exporting query results differs from creating a report. First, no additional information is added to the export output as you do when you create a report; only the output data is added to the report. Second, more formats are supported. The exported query results can be used for further processing using the supported machine-friendly formats such as XML and CSV. Reports are designed to be human readable, and as such are only output as PDF files.
Unlike query results in the console, exported data is not actionable.
For details about product features, usage, and best practices, click ? or Help.
Select Menu → Reporting → Queries & Reports, select a query, then click Run.
After the query runs, click Options → Export Data.
The Export page appears.
Select what to export. For chart-based queries, select Chart data only or Chart data and drill-down tables.
Select whether the data files are exported individually or in a single archive (.zip) file.
Select the format of the exported file.
CSV — Saves the data in a spreadsheet application (for example, Microsoft Excel).
XML — Transforms the data for other purposes.
HTML — Use this report format to view the exported results as a webpage.
PDF — Print the results.
If exporting to a PDF file, configure the following:
Select the Page size and Page orientation.
(Optional) Show filter criteria.
(Optional) Include a cover page with this text and enter the needed text.
Select whether the files are emailed as attachments to selected recipients, or they are saved to a location on the server to which a link is provided. You can open or save the file to another location by right-clicking it.
Click Export.
The files are either emailed as attachments to the recipients, or you are taken to a page where you can access the files from links.