ChrisG

Cross-tab report

Discussion created by ChrisG on Nov 30, 2017
Latest reply on Nov 30, 2017 by eric_evers


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.

 

Thank you

Outcomes