Cross-tab combining values in a column - any way to stop it?
Posted: Fri Sep 26, 2008 4:09 pm
I have a cross-tab report that looks something like this:
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:
(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?
Code: Select all
PMA PMA Name Dealer ...
0001 GEOG AREA 0001 DEALER 0001 ...
0002 GEOG AREA 0002 DEALER 0002 ...
Code: Select all
PMA PMA Name Dealer ...
GEOG AREA 0025 DEALER 0025 ...
0001 GEOG AREA 0026 DEALER 0026 ...
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?