Sorting or Grouping Problem!!??

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hello to Everybody,
I have built a database, which traces all the employees' training in the
factory. In the last mount, a problem has arisen and I am not able to solve
it. Probably I am loosing in a spot, but I am not able to see the solution.

The new circumstance is this one: The history report concerning all the
trainings attended by the employees even if they belonged to different
companies. I explain myself: an employee dismissed from an agency, because
he was engaged by our company. Now this person made several trainings with
both the companies.

The report is based on an internal query, which finds the fields into three
linked tables, (with ralation: one to sevaral):

TblCompany, TblEmployee, TblLessons. The used fields are as follows:
Company, Dismissal, Surname, Name, Date, Training, Hours, Department ed
Trainer.

I tried to build a layout having a Company Header, so that one can read the
Company name once only, without using unnecessary visual redundancies, such
as:

Company:Alpha, Dismissal x
Date, Trainig A, Hours, Department, Trainer
Date, Trainig B, etc,

Company: Beta, Dismissal
Date, Trainig C, etc,
Date, Trainig D, etc,

Total Sessions - Total Hours

But for an unclear reason, in the report the Company name is repeated on the
leftside of the Date, Training, etc. fields, creating unnecessary
redundancies

I made trials with the report wizard and manually, without coming to a
solution.
I hope someone can give me a usefull advice, meanwhile I thank you in
advance.
Kind regards
Marc

NB: The operative system is Windows 2000 and the application is Access 2000.
 
Marc,

I suspect you have the Company name field in the wrong
place. In your grouping you will need to have a "group
header" set for the company grouping. On your report the
Company name should only be in the "company group header"
section. If I have mis-understood your question please
include an example of what is appearing (I assume the
example below is what you want to appear).

HTH,

Terry
 
Terry said:
Marc,
I suspect you have the Company name field in the wrong
place. In your grouping you will need to have a "group
header" set for the company grouping. On your report the
Company name should only be in the "company group header"
section. If I have mis-understood your question please
include an example of what is appearing (I assume the
example below is what you want to appear).
HTH,
Terry
Click to expand...

Hi Terry,
thank you for your answer. Yes you are right, the example I posted in the
previous page is what I would have, meanwhile in the design report, the
layout is as follow:

- Report Header
Report Title with
Surname field
Name field

- Date Header
no field

- Company Header
Company field
boolean Dimissal field

- Body
Date field
Training field
Hours field
Department field
Trainer field

- Footer Page
=Now
=Page etc. (N°page of X pages)

- Footer Page Report
Tot. Sessions
Tot. Hours

Without the Date Header the company name is not repeated each time - and
that's right! - Nevertheless the Company names and the Trainings are not
listed by Date, as shown herebelow:

Actual Company: Alpha,
12/04/2004, Training C, Hours, Dept., Trainer
26/04/2004, Training D, Hours, Dept., Trainer
06/05/2004, Training E, Hours, Dept., Trainer

Previous Company: Omega, Dismissal x
23/03/2004, Training A, Hours, Dept., Trainer
28/03/2004 Training B, Hours, Dept., Trainer


The target I would like to achive is having the Companies and the Trainings
ordered by Date, but , at the moment, I am not able to see a solution.
Anyway I thank you for your answer.
Kind regards,
Marc
 
Marc,

I think you have you your groupings in the wrong order.

Your first grouping should be company and then date
grouping.

This will give you company headings and then the training
detail sorted by date within company.

Check your sorting in the grouping.

HTH,

Terry
 
Back
Top