supress data in report

[Guest]

Hi,

I have a report which lists stock purchasing requirements based on sales data.
The report has 2 groupings, firstly by Supplier, then by Item. The detail
section contains all Item Subtypes. So, to give some specific data:

SubItem = Tomatoes-Boxes; OnHand: 2; Sold:1; Required:-1
SubItem = Tomatoes-Each; OnHand: 0; Sold:10; Required:10
SubItem = Tomatoes-Kg; OnHand:0; Sold: 1.5; Required:1.5

These SubItems are all classified under the Item called Tomato. My program
converts are the different values of subitems into a standard value and
calculates the net requirements for the Item.

All this is working perfectly except that it obviously lists all items even
if they are not required overall.

Is there are way to supress the entire Header and Detail sections where
Sum([Required]) <- 0 ??

Rael

 

[Duane Hookom]

Create a totals query that groups to the Item level and calculates required
totals. Add this query to your report's record source so you can exclude
specific items from the report.

 

[Guest]

Thanks Duane,

Will do just that.
Was hoping there was a way to do it within the report.

Rael

Create a totals query that groups to the Item level and calculates required
totals. Add this query to your report's record source so you can exclude
specific items from the report.

--
Duane Hookom
MS Access MVP

Hi,

I have a report which lists stock purchasing requirements based on sales
data.
The report has 2 groupings, firstly by Supplier, then by Item. The detail
section contains all Item Subtypes. So, to give some specific data:

SubItem = Tomatoes-Boxes; OnHand: 2; Sold:1; Required:-1
SubItem = Tomatoes-Each; OnHand: 0; Sold:10; Required:10
SubItem = Tomatoes-Kg; OnHand:0; Sold: 1.5; Required:1.5

These SubItems are all classified under the Item called Tomato. My program
converts are the different values of subitems into a standard value and
calculates the net requirements for the Item.

All this is working perfectly except that it obviously lists all items
even
if they are not required overall.

Is there are way to supress the entire Header and Detail sections where
Sum([Required]) <- 0 ??

Rael

 

[Duane Hookom]

You can include the records in the report and add code to cancel the
printing of a section if a bound control has a particular value.
--
Duane Hookom
MS Access MVP

Thanks Duane,

Will do just that.
Was hoping there was a way to do it within the report.

Rael

Create a totals query that groups to the Item level and calculates
required
totals. Add this query to your report's record source so you can exclude
specific items from the report.

--
Duane Hookom
MS Access MVP

Hi,

I have a report which lists stock purchasing requirements based on
sales
data.
The report has 2 groupings, firstly by Supplier, then by Item. The
detail
section contains all Item Subtypes. So, to give some specific data:

SubItem = Tomatoes-Boxes; OnHand: 2; Sold:1; Required:-1
SubItem = Tomatoes-Each; OnHand: 0; Sold:10; Required:10
SubItem = Tomatoes-Kg; OnHand:0; Sold: 1.5; Required:1.5

These SubItems are all classified under the Item called Tomato. My
program
converts are the different values of subitems into a standard value and
calculates the net requirements for the Item.

All this is working perfectly except that it obviously lists all items
even
if they are not required overall.

Is there are way to supress the entire Header and Detail sections where
Sum([Required]) <- 0 ??

Rael