is it possible to export a report (generated from a template) with a pivot table to PDF?
If I try this, I always get some empty datafields in the pivot table instead of a filled pivot table as if I try to export it to .xlsx or .xls.
Sorry, this isn't currently supported. Right now, recalculating a pivot table is outside the scope of the component. The only way is to open the file in Excel and have it recalculate the pivot tables.