Home » Archived » BIRT » Suppress duplicates in crosstab report(Suppress duplicates in crosstab report)
Suppress duplicates in crosstab report [message #923661] |
Wed, 26 September 2012 04:54  |
Jeff Roberts Messages: 3 Registered: September 2012 |
Junior Member |
|
|
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: Mon Dec 11 14:57:08 GMT 2023
Powered by FUDForum. Page generated in 0.01958 seconds
|