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

First thought:  If you can structure a query for the summary report that has
as one of it's fields the sub-total, then you can filter out the rows which
are zero.

I've also used this in the detail section to skip a record based on a
condition but never in a group footer - but easy enough to test

In the format event

If sub-total=0 then 
	Me.MoveLayout = False
	Me.NextRecord = True
	Me.PrintSection = False
End if

IF these don't work we'll think of something else.

Rocky


-----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