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

Dear members I have some problem I subreporting. I am using iReport 1.3.0 version. My Table format: Employee Pay Scale Slip EmpId AllowanceType AllowanceId 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

My table format is given below Table1 Product ID Unit Price 1001 10 1002 1 1003 100 Table2 Product ID Warehouse Quantity 1001 Wh10 10 1002 Wh10 1 1003 Wh10 4 1001 Wh20 2 1002 Wh20 100 1003 Wh20 10 1001 Wh30 30 1002 Wh30 2 1003 Wh30 5 I want to create a report like Product ID Wh10 Wh20 Wh30 Total Quantity Amount Quantity Amount Quantity Amount Quantity Amount 1001 10 100 2 20 30 300 42 420 1002 1 1 100 100 2 2 103 103 1003 4 400 10 1000 5 500 19 1900 I have create a crosstab report in iReport 1.2.6 , I have select product ID as row group. But I don’t know which field I use as column group and details field. Please tell me the solution Thanks Shohan

I am using iReport 1.5.2 (java reporting tools) My table is as like Date warehouse delivery No 7/7/2006 10 10-1 7/7/2006 20 20-1 7/7/2006 20 20-2 7/7/2006 30 30-1 8/7/2006 10 10-2 8/7/2006 10 10-3 11/7/2006 30 10 30-2 11/7/2006 20 20 20-3 I want Output will be as like Date WH10 WH20 WH30 total delivery 7/7/2006 1 2 1 4 8/7/2006 2 0 0 2 11/7/2006 1 1 0 2 I can’t use crosstab in iReport Pls send me the steps of crosstab……..by which I can create this report what should I do???? Please help…… Thanks Mainur rahman

am using iReport 1.5.2 My table is as like Date warehouse delivery No 7/7/2006 10 10-1 7/7/2006 20 20-1 7/7/2006 20 20-2 7/7/2006 30 30-1 8/7/2006 10 10-2 8/7/2006 10 10-3 11/7/2006 30 30-2 11/7/2006 20 20-3 I want Output will be as like Date WH10 WH20 WH30 total delivery 7/7/2006 1 2 1 4 8/7/2006 2 0 0 2 11/7/2006 1 1 0 2 I can’t use crosstab in iReport Pls send me the steps of crosstab……..by which I can create this report what should I do???? Please help…… Thanks Mainur rahman