I have two tables called Resource, and Comment table structure is 1)Resource EntryNo                int ResourceNo        varchar(50) JobNo                varchar(50) Quantity        decimal(18, 0) 2)comment tablr CommentNo        int CommentLineNo        int comment                ntext Relation between two table is EntryNo in Resourse table and the commentNo in comment table are the same and one entry number will have n number of  comment in comment table my job  is to create a .rdl report with this two bale with using below query SELECT     Rsource.EntryNo, Rsource.ResourceNo, Rsource.JobNo,  Rsource.Quantity, Comment.comment, Comment.CommentNo,Comment.CommentLineNo FROM         Rsource left outer JOIN                       Comment ON Rsource.EntryNo = Comment.CommentNo its getting fine but when iam  caculating the total quantity for perticular entry no the total iam getting is wrong because of if quantity of perticular entryno is say 40 and this entry no is having 4 comments in comment table then the total quantity is 200(it is adding 4 times because i have 4 comments againest this entry no) Please suggest me how to get the exact total with out any duplication

Do you have a sample report output?  I'm not sure how you got 200 with 4 comments and 40 entries, wouldn't that be 160?

I'm using RAQ Report now. With it I can calculat totals easily. You can have a try. RAQ Report is free. You can get it at http://www.raqsoft.com/.