Charlotte Foust
charlotte.foust at gmail.com
Tue Sep 18 15:11:42 CDT 2012
If there is data (zero is data) in the control, the footer won't shrink. If you have any labels in the footer, it won't shrink unless their visibility it set to false. You might try setting the footer's MoveLayout to False as well. Charlotte On Tue, Sep 18, 2012 at 12:47 PM, Brad Marks <BradM at blackforestltd.com>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 >