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