Crosstab design advices needed

[CharleyDC5]

Hi folks,

I would like to add some specific non-group information in a crosstab but can't find a way to meet my requirements.

The first attachment (basic.jpg) shows the basic crosstab created by iReport, based on the following settings :
Row group (blue cells): $F{fileNumber}
Column group (yellow cells): $F{service Type}
Data (gray cells): $F{fileId} (function is SUM)

The second attachment (before.jpg) shows what I see when trying to display the information I want using measure, variable or fields. It just always return null.

Finally, the third one (expected.jpg) represents what I would like to see.

Any idea?

Thank you

Charles

Post Edited by CharleyDC5 at 02/24/2011 17:40

[baggypants]

Employee, Locations and Cost should all be additional row groups, not measures.

Or you could try concatenating them into one row group but you'd lose the column formatting.

Post Edited by baggypants at 02/24/2011 23:22