Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 15 Apr 2013 at 7:40am
There are two ways you can do this:
1. Filter the data out of the query in the subreport by setting the record selection criteria to {Table.MeasurementStatus} <> "Met". This will prevent the "Missed" records from even being pulled into the report.
2. If you need the "Missed" records for some reason, then you need to go to the Section Expert by right-clicking in the grey area to the left of the section where your data appears and selecting "Section Expert". Then click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!) and enter your formula. This will suppress the the display of the data but will not prevent it from being included in any counts, sums. etc.
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
