Eclipse Community Forums: BIRT » Suppress duplicates in crosstab report

Help

Home

Home » Archived » BIRT » Suppress duplicates in crosstab report(Suppress duplicates in crosstab report)

Show: Today's Messages :: Show Polls :: Message Navigator

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?

Report message to a moderator

Re: Suppress duplicates in crosstab report [message #923672 is a reply to message #923661]

Wed, 26 September 2012 05:13

Jeff Roberts

Messages: 3
Registered: September 2012

Junior Member

Note that there is actually a third dimension defined in the column area of the crosstab (hence the reason for using a crosstab) but I've found that the duplicate suppression behaviour occurs with D1/D2 in the column area regardless of whether D3 is defined.

Report message to a moderator