Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 22 Mar 2010 at 10:55am
Suppressing just hides the data, it does not remove it from the report.
Are you doing a running total? If so, are you evaluating all records? If so, then that is why. You can the running total evaluate on any boolean expression. Thus if you have the running total evaluate on the 'NOT' expression for your suppression, then that should 'eliminate' the values you do not want to count.
Joined: 08 Apr 2011
Location: United States
Online Status: Offline
Posts: 3
Posted: 04 Aug 2011 at 3:08pm
This is the same issue I was having trouble with. I have grouping by "location" and doing a running total on "procedure" with a reset on change of "location". It works perfectly except for the last "location" the running total always has a count of 1 less than the total.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum