Listing all values for a column in a cross-tab, even if duplicated?
Posted: Fri Dec 12, 2008 8:16 am
I've got a cross-tab report that can have multiple items in the same column with the same value. In part, it's supposed to look like this:
However, the default behavior of the cross-tab is to combine those values into a single value, like so:
Is there any way I can force it to show the value for each row in that first column, regardless of whether it's a duplicate or not? I've asked this question before, and was told to set the Summary property of the summary cell to none. This does not work, and it causes other problems besides.
Code: Select all
PMA PMA Name Dealer (other headers...)
0001 GEOG AREA 0034 DEALER 0034 (other values...)
0001 GEOG AREA 0035 DEALER 0035 (other values...)
0001 GEOG AREA 0036 DEALER 0036 (other values...)
Totals (other values...)
Code: Select all
PMA PMA Name Dealer (other headers...)
GEOG AREA 0034 DEALER 0034 (other values...)
0001 GEOG AREA 0035 DEALER 0035 (other values...)
GEOG AREA 0036 DEALER 0036 (other values...)
Totals (other values...)