I need to create what I think can be called a cross-tab report. I have a file of records; one column is product type. I need to display a count of each product type as a column in a report. There are thirteen possible types.
Is there a way to use SQL selects to count the types or do I have to use brute force and create a table of thirteen columns then scan the original table?
