Pivot Grid - Removing 'Grand Total' and Exporting as PDF (via Automation)

Afternoon All –

I’ve got a Pivot Grid set to run and export to PDF (and then email via Automation). My issue is that I need the PDF to generate in Landscape mode instead of Portrait. Is this possible, and if so, how can it be done?

Additionally, I’m wondering if there is any way to change the label of ‘Grand Total’ in my Pivot Grid to just ‘Total’ so that my columns are not so wide.

Any help would be appreciated.

Thanks in advance

Bummer. Automation doesn’t support those options. I entered CR100842 to add but they will not make the next release. Sorry.



I never had this kind of idea before,I’ve been fiddling with pivot grid control and know how to export grid to pdf, but I still can’t achieve your idea.

We recreated a request in QAT-2001 to track the issue.