[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[birt-report-designer-dev] Count , Sum and Grand Totals row :: How can we get in BIRT
|
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