Dear Fmp Guru's
I need some help with a cross-tab report, please.
There are two tables: Jobs and Technicians.
Each Job has one or more technicians assigned to it.
Each Job has a date.
Each Job has a status.
I am reporting from the Technicians table.
The report is divided into sub-sumary parts as follows:
Year, Month, Weak and Technician.
Here comes the cross-tab part of the report.
I would like to show the number of jobs for each technician by Job Status.
Eg: How many jobs that have the status "New", "Assigned", "Parts on order", "Parts arrived", etc
I am stuck with this cross tab part.