[birt-report-designer-dev] Count , Sum and Grand Totals row :: How can w

["Kranti Parisa" <kranti.parisa@xxxxxxxxx>]

Hi,

 

I have the database records like this

 

EmpID	Name	Department	Basic	Gross	Net
1	ABC	HRD	100	100	100
2	CEE	DEV	100	100	100
3	KKK	CEO	500	500	500
4	GGG	HRD	100	100	100
5	JJJ	DEV	100	100	100
6	LLL	CEO	500	500	500

 

 

I am trying to generate the report like this

 

EmpID	Name	Department	Basic	Gross	Net
Department: HRD
1	ABC	HRD	100	100	100
4	GGG	HRD	100	100	100
Dept Emp Count: 2			200	200	200
Department: DEV
2	CEE	DEV	100	100	100
5	JJJ	DEV	100	100	100
Dept Emp Count: 2			200	200	200
Department: CEO
3	KKK	CEO	500	500	500
6	LLL	CEO	500	500	500
Dept Emp Count: 2			1000	1000	1000
Total Emp : 6			1400	1400	1400

 

 

 

I am able to get the Groups for Department and counts. But not able to move forward to get the Sum for the columns like Basic , Gross, Net

 

and also the Grand Total Row.

 

Please suggest how can we achieve this in BIRT

 

Thanks in advance

 

 

--
------------------
Best Regards
Kranti Kiran Kumar Parisa
Mobile: +91 - 9849 - 625 - 625             +91 - 9391 - 438 - 738