Supressing lines in a report

E

Ernie Sersen

I have a report as follows
Item Qty Cost Value
ABC 3 10 30
BCD 0 8 0
DCE 2 4 8

How can I setup my report to supress items like BCD where QTY=0 from
displaying? I have a 41 page report that could be reduced to 6 pages if I
could keep the 'BCD's in my report from displaying.

Thanks.
 
D

Duane Hookom

The obvious answer is to set the criteria in your report's record source to
WHERE Qty <> 0
 
E

Ernie Sersen

Duane, that would be an obvious answer however, my data source is a little
more complicated. It is an inventory transaction report where items are
logged in and out of the database. There are no 'zero' quantities in the
source. The report uses a =SUM([Qty]) control to net out the transactions
which produces the zero. This states that the item is no longer in
inventory. However, the zero is still being listed on the report and that
is what I am trying to supress. If I turn the detail section on, the report
looks like this:

Item Qty Cost Value
ABC 3 10 30
abc1 1
abc2 2
BCD 0 8 0
bcd1 3
bcd2 -3
DCE 2 4 8
dce1 1
dce2 -1
dce3 2
 
D

Duane Hookom

I seemed to have missed all the additional requirements in your original
post ;-)

The easiest method might be to create a totals query that groups by Item and
sums Qty. Add this query to your report's record source and join the Item
fields. Set a criteria under SumOfQty to
<>0

--
Duane Hookom
MS Access MVP

Ernie Sersen said:
Duane, that would be an obvious answer however, my data source is a little
more complicated. It is an inventory transaction report where items are
logged in and out of the database. There are no 'zero' quantities in the
source. The report uses a =SUM([Qty]) control to net out the transactions
which produces the zero. This states that the item is no longer in
inventory. However, the zero is still being listed on the report and
that
is what I am trying to supress. If I turn the detail section on, the
report
looks like this:

Item Qty Cost Value
ABC 3 10 30
abc1 1
abc2 2
BCD 0 8 0
bcd1 3
bcd2 -3
DCE 2 4 8
dce1 1
dce2 -1
dce3 2




Duane Hookom said:
The obvious answer is to set the criteria in your report's record source
to
WHERE Qty <> 0
Click to expand...
Click to expand...
 
E

Ernie Sersen

Thanks! I'll give that a try. I figured I might have to work more in the
source than in the destination! I'll let you know how it goes.

Duane Hookom said:
I seemed to have missed all the additional requirements in your original
post ;-)

The easiest method might be to create a totals query that groups by Item and
sums Qty. Add this query to your report's record source and join the Item
fields. Set a criteria under SumOfQty to
<>0

--
Duane Hookom
MS Access MVP

Ernie Sersen said:
Duane, that would be an obvious answer however, my data source is a little
more complicated. It is an inventory transaction report where items are
logged in and out of the database. There are no 'zero' quantities in the
source. The report uses a =SUM([Qty]) control to net out the transactions
which produces the zero. This states that the item is no longer in
inventory. However, the zero is still being listed on the report and
that
is what I am trying to supress. If I turn the detail section on, the
report
looks like this:

Item Qty Cost Value
ABC 3 10 30
abc1 1
abc2 2
BCD 0 8 0
bcd1 3
bcd2 -3
DCE 2 4 8
dce1 1
dce2 -1
dce3 2




Duane Hookom said:
The obvious answer is to set the criteria in your report's record source
to
WHERE Qty <> 0

--
Duane Hookom
MS Access MVP

I have a report as follows
Item Qty Cost Value
ABC 3 10 30
BCD 0 8 0
DCE 2 4 8

How can I setup my report to supress items like BCD where QTY=0 from
displaying? I have a 41 page report that could be reduced to 6 pages
if
I
could keep the 'BCD's in my report from displaying.

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Top