sql server reporting services: Total field includes data from rows that were filtered -- sql server reporting services

Total field includes data from rows that were filtered

clberk
7/31/2006 1:44:01 PM

sql server reporting services: I am having the same problem that Cyndi posted on 5/10/06. I have a group
that has a filter on it. The group has a footer that has a Sum field. The
sum field is summing all data for the group, not just the rows that are
displaying. Has anyone come up with a solution for this problem? Is there

Re: Total field includes data from rows that were filtered

Ben Watts
7/31/2006 3:52:34 PM

you could always filter it in the actual dataset, or create a subreport with
that filter and then link it to the main report and put the sub in that
group displaying only the totals. In other words, the subreport would only
display the totals and thats it.
[quoted text, click to view]