Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 11 Feb 2010 at 1:00pm
Have you tried clicking on the 'Select Distinct Records' under the Database menu item. It is designed to remove duplicate records based on what fields are displayed.
In your first example there is no value for the Deelnemers column or Wie column (fourth row down), but there are values in the second example.
This should be a fairly easy issue to fix, not sure where we are going wrong.
Joined: 22 Dec 2009
Location: United States
Online Status: Offline
Posts: 10
Posted: 12 Feb 2010 at 8:31am
It appears that you are suppressing individual fields. Have you tried putting the formula into the Section Expert for the suppression?
ie: Details Suppresion formula:
(starttjid =next (starttjid)
and
Zaal = next (Zaal))
(something like that in the suppression formula for the Detals in the Section Expert should work. You can add more conditions if needed to the statement.)
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 12 Feb 2010 at 9:02am
Do not confuse supressing duplicate rows with excluding them from your totals. Suppressed data still exists and is still going to be included in totals.
You have to either exclude it fromt he report (e.g. Kevlray's suggestion of using Select Distinct records) or exclude it from your summarization via conditionally Running Totals or Variable formulas.
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
IP Logged
