Can we show duplicate row in cross tab.?

[sudhanshu.niit21]

Hi folks,

When Im working with cross tab, the repeted item is missing .I have 2 row with same amount in query ,but in cross tab it removes and displays only unique.

So, is there any property or solution or this?

Thanks in Advance :)

[Filip C.]

In case the two rows with the same label have a different key value in your source, you can add your key as extra group level in your crosstab (and hide it if needed) so the crosstab will first group on the key and afterwards on the label, resulting in two rows (or columns) for the same label.

Be aware the crosstab will sort on the key in this case, not on th elabel anymore, so you might be creative and cancatenate label '_' key or something like that to preserve sorting.

Regards,