[AccessD] Need to Suppress Subtotals that are Equal to zero (and Not Create Excess White Space on the Report)

Brad Marks BradM at blackforestltd.com
Tue Sep 18 14:47:52 CDT 2012


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



More information about the AccessD mailing list