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

Steve,

Yes, you can.

Charlotte

On Tue, Sep 18, 2012 at 1:10 PM, Steve Schapel <
steve at datamanagementsolutions.biz> wrote:

> Brad
>
> I haven't tested it, but I think you could use the Format event to
> manipulate the Visible property of the subtotals section of your report
> depending on whether it is zero.
>
> Regards
> Steve
>
> -----Original Message----- From: Brad Marks
> Sent: Wednesday, September 19, 2012 7:47 AM
> 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<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com/>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com/>
>