Visual Studio Report Designer - Grand Total Sums Wrong?

[misscrf]

I have a report that I am creating in Visual Studio 2005. This is what the data looks like:

SELECT     tbl1.Created, tbl2.Name AS Type, tbl3.DocExt, MAX(tbl1.ItemCount) AS ItemCount, 
                      MAX(tbl1.ItemTotal) AS ItemTotal, MAX(tbl1.RecordsWritten) AS RecordsWritten, MAX(tbl1.Size) AS Size, 
                      COUNT(tbl3.DocID) AS CountOfDocID
FROM         tbl3 WITH (nolock) LEFT OUTER JOIN
                      tbl2 WITH (nolock) ON tbl2.ID = tbl3.TypeID LEFT OUTER JOIN
                      tbl1 WITH (NOLOCK) ON tbl3.EDSessionID = tbl1.ID
GROUP BY tbl1.Created, tbl2.Name, tbl3.DocExt

This is what the layout looks like:

http://www.geocities.com/misscrf/ReportLayout.JPG

This is what the preview looks like, which is summing the group 1 stuff, but gives me wrong totals.

http://www.geocities.com/misscrf/ReportPreview.JPG

I have looked all over for how to correct this, but you will see that the sum of the item totals is all wrong. How do I fix this please?


misscrf

It is never too late to become what you could have been ~ George Eliot

 

[misscrf]

can no one help me?

misscrf

It is never too late to become what you could have been ~ George Eliot