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 happens when widgets have pagination enabled, or when media widgets are used as headers without the proper settings. This guide will walk you through ensuring 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 (i.e. three dots icon) at the top of the dashboard.
2] You will see two options under the "Report Output":
Dashboard: Selecting this option ensures that all data grid widgets with pagination enabled will be displayed on the last page of the entire report.
Section: Selecting this option ensures that all data grid widgets with pagination enabled will be displayed on the last page of their respective sections.
Turn On Pagination for Data Grid Widgets
Turning on pagination for data grid widgets is essential for ensuring that all rows—particularly 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 has been placed above a data grid widget to serve as a header, ensure 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
- Once these settings are updated, 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.
-
Following these steps should resolve any issues related to incomplete data in PDF downloads for data grid widgets.