Exporting Dashboard to PDF and Emailing - Data is truncated

[Sandy7]

Hello - hoping someone can help.

I have a dashboard that has list reports added. When I export to PDF and have it delivered through email, the data on the list reports is being truncated. is there  a way to fix this so data is not being truncated?

[Jaspal Singh]

Hi,

Did you check the export limit from Application Navigator System Properties >> Import Export. There is a need for you to increase the limit it seems.

[Sandy7]

Hi yes I checked the settings and it's at 1000. 

HHere is what the dashboard looks like when I export  to a pdf and email - you can see it's cut off

[Raymond Ferguso]

I've found the export to PDF is a little lackluster when there is anything fancy on the page.  What usually works when I run into those issues is to use the super secret "printer friendly version" and the browser or OS print to PDF option.

It's super secret because it is in the least intuitive spot.

> Click the settings gear on upper right.

> Within the settings modal, click "Printer Friendly Version"

I'm not sure if this will work for a dashboard, but it sure helps if you have HTML fields or journals with HTML in [code][/code] blocks.

[Raymond Ferguso]

Apparently there is a PDF macro, so if you open the print view, then copy the URL, and append &PDF to the url it downloads the print view as a PDF, likely rendering with the server-side PDF libraries, and the print view formatting.

Alternately, it looks like print view just adds a few params to the get request.

sysparm_stack=no&sysparm_force_row_count=999999999&sysparm_media=print

[Sandy7]

Hi so yes the "Printer Friendly" option didn't help the issue. I think it's because you have to scroll on the report to view all of the records. Anyone know if it's possible to fix this?