A crosstab report is a report that summarizes values in both rows and columns. For example, I just added a crosstab report for the revision of InBizness SOHO that I’m working on. This report can be used my the marketing department to get an overall idea of client activity ranging from campaigns, proposals, quotes, sales orders, invoices and invoice totals.
There is no built in assistant within FileMaker to build crosstab reports but there are multiple ways in which to design them using your skills as a FileMaker developer. Each method will have its advantages and disadvantages in key areas such as ...
- the amount of time to create the report
- how complex the report is to create
- how flexible the report is for recycling for other needs
- how large of a schema footprint it leaves (extra fields, layouts, scripts)
- how well it can handle extremely large sets of data
Crosstab reports can be very handy and it is something you will want to have in your overall FileMaker reporting skills portfolio.
More info about the author and FileMaker in general, contact me at firstname.lastname@example.org.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.