Cross Tab CSV Column Export Problem
Posted: Thu Jan 16, 2014 3:18 pm
Hi everyone,
Whenever I create a report with a cross-tab and attempt to export it to CSV format, the column header in the CSV always appears as:
"CrossTab1_Row1;CrossTab1_Sum1;CrossTab1_Sum1;CrossTab1_Sum1"
So for example, if I have a report with the following column headers: Column 1 = User, Column 2 = a, Column 3 = b, Column 4 = c
then instead of the first row in the exported CSV being User;a;b;c it will be: CrossTab1_Row1;CrossTab1_Sum1;CrossTab1_Sum1;CrossTab1_Sum1
I've attached a sample output with this post for reference.
Does anyone know how to fix this?
Regards,
Anil.
Whenever I create a report with a cross-tab and attempt to export it to CSV format, the column header in the CSV always appears as:
"CrossTab1_Row1;CrossTab1_Sum1;CrossTab1_Sum1;CrossTab1_Sum1"
So for example, if I have a report with the following column headers: Column 1 = User, Column 2 = a, Column 3 = b, Column 4 = c
then instead of the first row in the exported CSV being User;a;b;c it will be: CrossTab1_Row1;CrossTab1_Sum1;CrossTab1_Sum1;CrossTab1_Sum1
I've attached a sample output with this post for reference.
Does anyone know how to fix this?
Regards,
Anil.