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