Home » Archived » BIRT » Suppress duplicates in crosstab report(Suppress duplicates in crosstab report)
Suppress duplicates in crosstab report [message #923661] |
Wed, 26 September 2012 00:54  |
Eclipse User |
|
|
|
I've created a report that uses a crosstab containing two dimensions and two measures. When running the report, I've found that duplicate values of the first dimension are suppressed when they are encountered with different values for the second dimension.
e.g. Suppose we have the following data represented in the data cube from which the crosstab is built:
D1, D2, M1, M2
Fred, Red, 10, 20
Fred, Blue, 30, 40
Alf, Black, 50, 60
Alf, White, 70, 80
When reported, this comes out as:
D1, D2, M1, M2
Fred, Red, 10, 20
<blank>, Blue, 30, 40
Alf, Black, 50, 60
<blank>, White, 70, 80
Given that the report user wants to export data to Excel and potentially filter/manipulate the data, they would prefer that the D1 value suppression doesn't happen.
From my examination of the crosstab properties, there doesn't seem to be a "Suppress Duplicates" property, as appears for a column on a normal table. As such, is there any way of overriding this auto value suppression behaviour in a crosstab?
|
|
| | | |
Goto Forum:
Current Time: Thu Jul 03 04:10:19 EDT 2025
Powered by FUDForum. Page generated in 1.07947 seconds
|