Author Topic: Group Column are not export in excel and csv?  (Read 2767 times)

Pardgroup

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 2
    • View Profile
Group Column are not export in excel and csv?
« on: July 31, 2015, 05:28:41 pm »
Greetings,
We have a problem with the MAIN column header not being exported in excel when there are SUB-columns.
So in case there are 3 SUB-columns equal for different MAIN columns the result is an excel or csv with no indication for which MAIN column are the SUB-columns.

Example let's say we have MAIN columns as clusters and they are named: Cluster Paris, Cluster Italy, Cluster Spain
under each MAIN columns we have 3 sub columns: Quantity-A, Quantity-B, Quantity-C

In Param query everything is okay, I can identify the 3 SUB columns for each cluster but in excel, csv I don't have the 3 MAIN columns: Cluster Paris, Cluster Italy, Cluster Spain. So image that in an excel with 20 MAIN columns.

Any hints for fix that?
thanks, Best Alberto.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
Re: Group Column are not export in excel and csv?
« Reply #1 on: July 31, 2015, 06:34:59 pm »
Alberto

Currently it only exports the lowest level columns when columns are grouped in the header.

Ability to export all the grouped columns would be added in one of the next releases, thanks for your feedback.