Overview
When users download a report as a PDF from a dashboard, the content in data grid widgets, including images or rows, may appear incomplete or cut off. This often occurs when pagination is enabled on widgets or when media widgets are used as headers without the correct settings. This guide will help you ensure that all data grid widget rows and images are correctly included in the final PDF.
Adjust Reporting Options
1] Navigate to Edit Reporting Options by clicking More Options (three dot icon) in the top right corner of the dashboard.
2] You will see two options under the "Report Output":
Dashboard: This option places all data grid widgets with pagination enabled on the last page of the full report.
Section: This option places each paginated data grid widget on the last page of its respective section.
Turn On Pagination for Data Grid Widgets
Turning on pagination for data grid widgets is essential to ensure that all rows, especially in widgets with multiple pages, are included in the PDF download. Without pagination, only the visible rows in the widget at the time of download will be captured.
To enable pagination:
1] Go to the data grid widget settings.
2] Toggle the Pagination option to ON.
This is crucial to prevent rows from being cut off when the report is downloaded.
Ensure Media Widgets are Set as a Header (If Applicable)
If a media widget is placed above a data grid widget to serve as a header, make sure the Use Widget as Header option is enabled. If this step is skipped, the header may appear multiple times in the report, leading to formatting issues.
Refer to this article for more information on setting up widgets as headers.
Final Check
- After updating these settings, try downloading the dashboard again:
-
All data grid widget rows, including any paginated data, should now appear correctly in the PDF.
-
Widget headers, particularly those set with media widgets, should no longer be duplicated or incorrectly formatted.
-
These steps should resolve any issues related to incomplete data in PDF downloads for data grid widgets.