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

I agree, Jim.  OnPage is full of surprises, and it doesn't happen at the
right time, just as OnPrint is too late for anything but drawing lines.

Charlotte

On Wed, Sep 19, 2012 at 4:50 AM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  Got to be careful with OnPage though.  I've found that doing anything
> other
> then adding to what's already there (like drawing a border) doesn't work
> well if at all.
>
>  For hiding things, much better to handle things in the OnFormat event
> before it even gets placed on the page.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Tuesday, September 18, 2012 06:00 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Need to Suppress Subtotals that are Equal to
> zero(andNot Create Excess White Space on the Report)
>
> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>