Stuart McLachlan
stuart at lexacorp.com.pg
Tue Sep 18 16:11:13 CDT 2012
My first approach would be to modify the underlying query to group on part number, count(mannufactured), count(shipped) and filter for manufactured <> shipped. Then put the data in the detail. IOW, make the query engine do the work rather than the report engine. It's likely to be far simpler. -- Stuart On 18 Sep 2012 at 14:47, Brad Marks wrote: > All, > > I have an existing report that summarizes Sales Orders. For each Part > on each Sales Order, there is a line that shows the number of parts > manufactured and the number of parts shipped. This is working nicely. > > This report also has a subtotal on the number of parts. In 99% of the > cases, this subtotal will be 0, as the number of parts that are > manufactured *should* be the same as the number of parts shipped. This > subtotal is working nicely also. > > Recently, there has been a request to create a variation of this report > that does not show details, but ONLY shows subtotals that are not zero. > This will save time for our users as they will not need to wade through > many pages of the existing report looking for subtotals that are not > zero. > > I have set up a new report that only shows subtotals. In the Subtotal > Footer "On Print" event, I have coded "Cancel = True" if the subtotal > amount is zero. > > This works, but there are now blank lines on the report for all > subtotals that are zero. > > I have set the Subtotal Footer and the two fields in the footer to "Can > Shrink = YES" > > I am trying to figure out how to prevent the white space from being > generated for subtotals that are being suppressed. > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >