Listing all values for a column in a cross-tab, even if duplicated?

[korthmat]

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:

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

However, the default behavior of the cross-tab is to combine those values into a single value, like so:

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

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.

[Edward]

Hi.

You are right.

This feature is not supported right now. We have added it in our to-do list.

We will inform you in this topic when this feature is available.

Thank you.

[Vital]

Hello,

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

Thank you.