Exporting Pivot Tables to PDF
You can export pivot table widgets in PDF format. Through the PDF Report Settings page, you can customize how your table is displayed in your PDF report including the table’s orientation and page size. In the PDF Report Settings, the first 14 pages of your Pivot table are displayed in the Preview window, however, when you export your Pivot table to PDF, the entire table is included, up to 8,000 rows on multiple pages. The system will automatically cut off the excess rows.
To export a Pivot table widget to PDF:
- In the Widget menu, select Download > PDF File.
- The PDF Report Settings page is displayed.
- You can apply the following settings:
| Setting | Description |
|---|---|
| Paper Size | The size of the email report in the PDF. |
| Orientation | The orientation of the dashboard in the PDF, landscape or portrait. Landscape orientations display the dashboard horizontally while portrait orientations display the dashboard vertically. |
| Header |
The design and content of your report’s header. The header is displayed on the top of each page or your PDF report. From the Header list, you can define how your header is to be displayed: Compact, Medium, Large, or No Header. After you have set the design, you can determine what information is included in the header. Title: Select to display the dashboard name at the top of the PDF. Dashboard As Of: Select to display the Database name and last update time at the top of the PDF. Dataset Name: Select to display the name of the Database that contains the dashboard’s data. Dashboard Filters: Select to display dashboard filter selections. |
| Footer | The content displayed in the footer section of each page of your report. You can display the following information: Page Number: Select to display the page number on each page of the report. |
- In the Preview area, click the title to edit the text, size, and alignment of the title.
- Click Download to download your report.
