hiding duplicative data in a report

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

need help here...

i have a report based on a query that has 3 major fields
from 2 tables:

from table 1, i have
1) name of product and
2) description of the product

from tabel 2, i have
3) associated parts with the product name/id

field #2 is a memo field, and field #3 has many records
for each product.

the question i have is:

when i print a report based on this setup, my report goes
too many pages for each product due to its long text -
field #2. even after i used "hide duplicates" option for
the field #2, each page can only hold about 3 or 4
records. whenever there are more than 5 records for its
associated parts, the new page is added and the
description of the product [field #2] repeats - wasting
lots of spaces.

any ideas to get rid of this field #2 in the subsequent
pages?

thanks much in advance. kim.
 
kim said:
need help here...

i have a report based on a query that has 3 major fields
from 2 tables:

from table 1, i have
1) name of product and
2) description of the product

from tabel 2, i have
3) associated parts with the product name/id

field #2 is a memo field, and field #3 has many records
for each product.

the question i have is:

when i print a report based on this setup, my report goes
too many pages for each product due to its long text -
field #2. even after i used "hide duplicates" option for
the field #2, each page can only hold about 3 or 4
records. whenever there are more than 5 records for its
associated parts, the new page is added and the
description of the product [field #2] repeats - wasting
lots of spaces.

any ideas to get rid of this field #2 in the subsequent
pages?
Click to expand...


If the memo field is associated with the product info and is
not associated with the parts info, the you don't want the
memo fielf in the detail section at all.

Use Sorting and Grouping (View menu) to create a group (with
header) on the product field. Then you can place the
product associated info in the group header section and the
parts info in the detail section. This way, there will no
duplicated stuff to get rid of.
 
thanks much. it worked!!!
-----Original Message-----
kim said:
need help here...

i have a report based on a query that has 3 major fields
from 2 tables:

from table 1, i have
1) name of product and
2) description of the product

from tabel 2, i have
3) associated parts with the product name/id

field #2 is a memo field, and field #3 has many records
for each product.

the question i have is:

when i print a report based on this setup, my report goes
too many pages for each product due to its long text -
field #2. even after i used "hide duplicates" option for
the field #2, each page can only hold about 3 or 4
records. whenever there are more than 5 records for its
associated parts, the new page is added and the
description of the product [field #2] repeats - wasting
lots of spaces.

any ideas to get rid of this field #2 in the subsequent
pages?
Click to expand...


If the memo field is associated with the product info and is
not associated with the parts info, the you don't want the
memo fielf in the detail section at all.

Use Sorting and Grouping (View menu) to create a group (with
header) on the product field. Then you can place the
product associated info in the group header section and the
parts info in the detail section. This way, there will no
duplicated stuff to get rid of.
Click to expand...
 
Back
Top