supress data in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Thanks Duane,

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

Rael

Duane Hookom said:
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

rael_lucid said:
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
Click to expand...
Click to expand...
 
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

rael_lucid said:
Thanks Duane,

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

Rael

Duane Hookom said:
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

rael_lucid said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top