A crosstab query is a specific query used to create aggregate
reports on two or more fields, it’s a handy way to display
summary information. At Open Query we have customers using that
trick to display production schedules.
The summary table is generated from the database to extract the
manufacturing date (mand), unit number (unitn), product area
(pro_area), and ranking (rnk). Then we can start using that
summary table to process our crosstab. The summary table looks