Help on report

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

Guest

Hello,
I'm making a report from a query that is ordered by 2 fields.
So I have a order by Supervisor, where I have 3 records, Technical
Supervisor, Comercial Supervisor and Sales Supervisor, and I want to make a
report where it shows every emploeyes that are under each Supervisor, but I
don't want to show in all the lines of the record the Department Supervisor,
I just would like to see one time the department supervisor and then only see
it again when the supervisor is different.
As example, normally the reports shows like this:

Supervision: Technical Supervisor
Name: David
Occupation: ....
-----------------------------------------
Supervision: Technical Supervisor
Name: Stan
Occupation: ....
-----------------------------------------
Supervision: Sales Supervisor
Name: Mike
Occupation: ....

And so on... and I would like to see it like this:

Supervision: Technical Supervisor
Name: David
Occupation: ....
-----------------------------------------
Name: Stan
Occupation: ....
-----------------------------------------
Supervision: Sales Supervisor
Name: Mike
Occupation: ....

And so on...
Hope anybody understands my idea.

Thanks in advance.
 
Use your grouping and sorting dialog box while in report design view. If
the report is sorted and grouped by supervisor you should get what you need.
MAke sure to include a group header and place the supervisor in the header.

Rick B
 
David,
You neeed to set up a GroupHeader on your Supervision field, using the
Grouping/Sorting Dialog box in report design mode. Being familiar with the
concepts and mechanics of Grouping and Sorting is a critical aspect of
reporting.

Create a GroupHeader for [Supervsion], and place your [Supervision] field
in it.
In the Detail Section just below, insert the [Name] and [Occupation]
fields.
You should then get the results you indicated in your post...
hth
Al Camp
 
Back
Top