KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Pivot Table View - Export Map-dataField #1632

Open Oya Kaynar opened this topic on on Sep 28, 2020 - 3 comments

Oya Kaynar commented on Sep 28, 2020

VİEW - How can I fix headers according to pivot table map datafiled row fields?

1.

EXPORT - How can I hideSubtotalRow => true in pivot table export and edit map datafiled name?

2.

David Winterburn commented on Sep 28, 2020

Hi Oya,

Regarding PivotTable's map for data fields for both web view and export, please use "dataField" key like in this documentation:

https://www.koolreport.com/docs/pivot/pivottable_and_pivotmatrix/#properties-map-(version-%3E=-5.0.0)

As for "hideSubtotalRow", which type of export were you refering to, Pdf or Excel? Thanks!

Oya Kaynar commented on Sep 29, 2020

Hi David, Excel export "hideSubtotalRow"

David Winterburn commented on Sep 29, 2020

Hi Oya,

To use "hideSubTotalRows" in PivotTable's excel export, please use Excel package's PivotTable widget in a template:

https://www.koolreport.com/docs/excel/export_to_excel/#excel-export-template-(version-%3E=-6.0.0)

Let us know if you have any problem with this. Thanks!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

Pivot