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

Charlotte Foust charlotte.foust at gmail.com
Tue Sep 18 17:53:21 CDT 2012


One of the many useful applications of grouping in Access reports that some
"experts" apparently don't know about.

Charlotte

On Tue, Sep 18, 2012 at 2:59 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> Hi Brad :
>
> If you haven't done so look report Events section. Check out "On Page"
> event. This where I would put the code to check for a zero balance and turn
> off the field altogether. You might check into adding different groups and
> put the balance display within one of these group...if a balance is zero
> turn off the group display.
>
> Something like:
>
> Me.BalanceFooterSection.Visible = (Me.Balance <> 0)
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Tuesday, September 18, 2012 12:48 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Need to Suppress Subtotals that are Equal to zero
> (andNot
> Create Excess White Space on the Report)
>
>  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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list