Sub report in iReport

[shohan_db]

Dear members

 

I have some problem I subreporting.

I am using iReport 1.3.0 version.

 

My Table format:

Employee Pay Scale Slip

 

Employee Id Allowance Type Allowance Id Amount

1001 0 1 8000

1001 0 2 3000

1001 1 1 600

1002 0 1 10000

1002 1 1 600

 

 

I want to create the following report in iReport

 

 

 

Employee Id 1001

 

Allowance type (0) Allowance type (1)

(Amount) (Amount)

8000 600

3000

 

Total 11000 600

 

---------------------------------------------------------------------

 

Net salary 10,400

 

 

I have Create the sub report and successful to distinct allowance Type 0 and 1’s amount.

But I cannot sum the sub report total and net salary of the employee

 

How can I sum all the amount of Allowance Type 0 and 1.

And After that how can calculate the net salary of employee??

Please help me

 

Thanks

shohan