I have created a report in RTC. Sum is not getting calculated correctly even though I have used sum function .Value in body parts are correct but sum calculated is worn .Does any one one y this is happening ?
Check your data set values and can show us the rdlc screenshot…is there any groping?
3438.Output.bmp (3 MB) 1524.Rdlc.bmp (1.22 MB)
there are no grouping and data set values are also right .The screen shot is as above
May be because of no grouping the sum is the total of all Purchase lines qty and line amount…
Group it with Document no. and try
After grouping sum is coming as twice the value it should be .The lines in the body of the table are reprated twice if not grouped with Document No.
Check the standard report how it is working…