Page 1 of 1

Cross-tab combining values in a column - any way to stop it?

Posted: Fri Sep 26, 2008 4:09 pm
by korthmat
I have a cross-tab report that looks something like this:

Code: Select all

PMA   PMA Name            Dealer   ...
0001  GEOG AREA 0001  DEALER 0001  ...
0002  GEOG AREA 0002  DEALER 0002  ...
The problem is, under certain circumstances, the first column (PMA) can have the same value for multiple successive rows, so in those cases we get something like this:

Code: Select all

PMA   PMA Name            Dealer   ...
      GEOG AREA 0025  DEALER 0025  ...
0001  GEOG AREA 0026  DEALER 0026  ...
(The PMA column has its vertical alignment set to Bottom.)

Is there a way to get this working so that it lists the PMA code for each row, regardless of whether it's repeated or not?

Cross-tab combining values in a column - any way to stop it?

Posted: Sat Sep 27, 2008 1:34 am
by Vital
Hello,

Please set Summary property of summary cell to None.

Thank you.

Cross-tab combining values in a column - any way to stop it?

Posted: Wed Oct 01, 2008 8:13 am
by korthmat
Please set Summary property of summary cell to None.
Unfortunately, that doesn't solve the problem. Plus, although I didn't show it, there's also a totals row on the report, and setting Summary to None kills the totals (not the row, just the totals themselves).

Cross-tab combining values in a column - any way to stop it?

Posted: Sat Dec 13, 2008 8:32 pm
by Vital
Hello,

Please check build from 15 Dec. We have added new property to Columns and Rows - MergeHeaders.

Thank you.