I am using SQL 2005 reporting services accessing a SQL 2000 server (I'm going to migrate the data over later).
The program I am having is that I am grouping on a field but when I try and sum on another field, it adds up all of the items instead of those just being displayed.
For example, this would be a collection of records:
Well I want it to just sum up the 5 and 3 once and give me 8, instead it give me 21.
I'm looking to just perform a SUM on the items that are actually displayed on the screen. I have searched all over and found others with similar problems, but no solution.
I have been able to do a SUM just on the ReportItems!textbox.Value, but the problem with that is I can only place the results on header or footer.