Suppress printing of value after it has first appeared.

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

Guest

I have a report which I would like to suppress printing of a values once it
has appeared. I have used the HideDuplicate property, but that only applies
to a single page. I really want to print the value ONLY once within the
entire report. I have a VB script that partially works, by comparing the
current page to the previous page; however, it fails when the data crosses to
a 3rd page.

How can I suppress the printing of a value on ALL pages, after it has
appeared (first use)?
 
dsc2bjn:

In the report's underlying query, why don't you set it to only output
distinct values, that would eliminate the problem without code. Use the
query's properties to so this.
 
Let me try explain this better.

Let us say we have a database for FOOD.

Within the database there are categories of food.

Meat, Fruit, Breads/Cereals, Vegetables

Within each of these categories there are Sub-Categories.

Meat may have Beef, Poultry, Pork

Within the subcategories there may be further delineation.

Poultry contains Chicken, Turkey, Phesant, Cornish Game Hens.

Each of these may have two or more items listed.

Turkey may be listed as wild, mass produced, farm raised

So...my out put is distinct for each record.

Meat, Poultry, Turkey, Wild
Meat, Poultry, Turkey, Mass Produced
Meat, Poultry, Farm Raised

I wish to only PRINT Meat ONCE. I only Want to PRINT Poultry ONCE, I want
to PRINT Turkey ONCE on my report.

Meat, Poultry, Turkey, Wild
Mass Produced
Farm Raised

I know I can use the sort and group function to do this; however, the client
does not like the appearence.

Meat
Poultry
Turkey
Wild
Mass Produced
Farm Raised

It takes up too much space. Setting the value of Hide Duplicates only
applies to a single page. The client only wishes to see the Classification
(Meat, Poultry, Turkey) of the item (in this case Wild, Mass Produced, Farm
raised) once on the entire report.

I hope this explains it better.
 
Back
Top