Home » Eclipse Projects » BIRT » Suppress duplicates in crosstab report (Suppress duplicates in crosstab report)
| Suppress duplicates in crosstab report [message #923661] |
Wed, 26 September 2012 00: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?
|
|
|
Current Time: Sun May 19 18:15:23 EDT 2013
Powered by FUDForum. Page generated in 0.01933 seconds
|
] 
Search
Help
Register
Login
Home
