[Report Design problem]

Dear sir,

I am totally a new user of ireport.   I have four tables. The Tables are given below.

 

 

 

1. inv_profile:

accnt_no	ac_name1
23	Prasun Kanti
45	Babu

2. psdr_cds:(Use for Buy)

accnt_no	no_shares	trans_dt	comp_cd
23	40	1-jan-2006	101
45	70	11-dec-2011	101
23	20	1-nov-2011	101

3. swr_cds(Use for Sale)

accnt_no	no_shares	trans_dt	comp_cd
23	20	1-jan-2007	101
45	20	12-dec-2011	101
23	30	15-nov-2011	101

4. comp

comp_cd	comp_nm
101	AB BANK

 

Now i need a Report same :

 

Accnt_no       Name                       Total Buy                  Total Sale         Balance

 

23                  Prasun Kanti             60                              50                     10

45                   Babu                        70                               20                   50

 

I am try to solve this problem but i am unable to do this. Please help me about this report.

Thanks

Post Edited by prasunkanti at 12/13/2011 02:41

Post Edited by prasunkanti at 12/13/2011 02:42