Need help with a report......do I need a subreport?

[FatMan]

Hi all:
I have created a report that shows the records as:

Block #1
Trans#1 Date#1 Prod#1 Pest#1
Trans#1 Date#1 Prod#1 Pest#2
Trans#1 Date#1 Prod#2 Pest#1
Trans#1 Date#1 Prod#2 Pest#2
Trans#2 Date#2 Prod#1 Pest#3
Trans#2 Date#2 Prod#2 Pest#3

Block #2
Trans#1 Date#1 Prod#1 Pest#1
Trans#1 Date#1 Prod#1 Pest#2
Trans#1 Date#1 Prod#2 Pest#1
Trans#1 Date#1 Prod#2 Pest#2
Trans#3 Date#2 Prod#1 Pest#4
Trans#3 Date#2 Prod#2 Pest#4

After showing the report to some users they would like to see the report to
look like:

Block #1
Trans#1 Date#1 Prod#1
Prod#2
Pest#1
Pest #2


Trans#2 Date#2 Prod#1
Prod#2
Pest#3


Block#2
Trans#1 Date#1 Prod#1
Prod#2
Pest#1
Pest#2


Trans#3 Date#2 Prod#1
Prod#2
Pest#4

Can anyone out there help me with this? Any and all help is greatly
appreciated.

Thanks,
FatMan

 

[KARL DEWEY]

Open report in design view and change the Hide Duplicate property to Yes of
those text boxes.

 

[FatMan]

Karl:
Thanks for your post.

I have tried the Hide Dupllicate property thing and it didn't do what I
wanted to do.

What I am looking for the report to do is to display/print all the detail
records for a given Trans # showing all the detail records for the Products
used and then followed by all the detail records for the Pest targeted with
the products used.

If it helps all the information is comming from the one table.

Thanks,
FatMan

 

[KARL DEWEY]

Use the report Grouping and Sorting.
Group on Block #.
Put Block # in group header.