Enabling Pagewise Export and Customizing Record Counts in Grid Widget Export As PDF

By default, only the current page of the widget is exported when exporting the grid as a PDF in Bold BI. However, you can enable pagewise export support and customize the record count by following the below steps. This feature is particularly useful for viewing large datasets as PDFs.

Steps to Enable Pagewise Export

1. Go to the dashboard viewer page by rendering the dashboard.
2. Hover over the Grid widget and click on the “More Options” icon in the widget header.
3. Select the “Export” option and choose “PDF”.
   
   
4. In the PDF Export dialog, enable the “Enable pagewise exporting” checkbox.
5. Customize the “Page Size” and “Orientation” settings, then click “Export”.
   
   

Steps to Customize the Record Count While Exporting

By default, only 500 records will be exported as a PDF when pagewise exporting is enabled. You can customize the record count using the PageWiseExportRecordCount value as follows.

Windows

1. Open the appsettings.json file located at:

   {deployment_location}\bi\dataservice\appsettings.json
   

2. Customize the record count in the PageWiseExportRecordCount node and save the file.
3. Export the widget by enabling the “Enable pagewise exporting” checkbox to export the grid with the configured number of records.

Linux

1. Open the appsettings.json file from the deployment location by running the following commands:

   cd /var/www/bold-services/application/bi/dataservice/
   sudo nano appsettings.json
   

2. Customize the record count in the PageWiseExportRecordCount node.
3. To save the changes, press Ctrl + X, then Shift + Y, and Enter.
4. Export the widget by enabling the “Enable pagewise exporting” checkbox to export the grid with the configured number of records.

Docker & Kubernetes

Add the AppSettings__PageWiseExportRecordCount environment variable on the designer service and set it to the desired value.

Additional References

• Exporting Options in Bold BI
• Data Visualization Using Grid Widget
• Environment Variable in Kubernetes
• Environment Variable in Docker