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

[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?

[Vital]

Hello,

Please set Summary property of summary cell to None.

Thank you.

[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).

[Vital]

Hello,

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

Thank you.