How can crosstabs do? (Multi columns in column total group)

[thomc]

Hi everyone!

I have a problem when i design the crosstab report: 

This is Report collect Sales and Spends of many Companies by some Index name:

 

			SUM BY COMPANY			COMPANY 1			COMPANY 2
Order	Index	Units	SALES	SPENDS	UNEQUALS	SALES	SPENDS	UNEQUALS	SALES	SPENDS	UNEQUALS
A	B	C	1	2	3	4	5	6	7	8	9
I	Fuels	USD	200,000	170,000	30,000	100,000	90,000	10,000	100,000	80,000	20,000
1	Gas	USD	200,000	170,000	30,000	100,000	90,000	10,000	100,000	80,000	20,000
2	Oils	USD
3	Oils FO	USD
4	Other fuels	''

I have datasource with bean properties, and they are fields when i design by iReport 4.0 :

    private BigDecimal value;

    private String companyName;

    private String columnName;

    private String indexName;

    private String indexOrder;

    private String unit;

   

I want to use Crosstab but i don't know how to add Sum Column ex SALES by Company in Column Total. And how to put them in Column Total.

Pleased, give me some solutions for this!

Thanks for your attention!

[thomc]

Anyone can help me?

Thanks!