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

  • Thread starter Thread starter FatMan
  • Start date Start date
F

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
 
Open report in design view and change the Hide Duplicate property to Yes of
those text boxes.
 
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
 
Use the report Grouping and Sorting.
Group on Block #.
Put Block # in group header.
 
Back
Top