From the course: Advanced FileMaker Pro 12
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating a crosstab report - FileMaker Pro Tutorial
From the course: Advanced FileMaker Pro 12
Creating a crosstab report
SubSummary reports like those covered in the previous movies will solve many of your reporting needs in FileMaker but there are some report formats that don't necessarily work that well in these SubSummary report or grouped format. Say for instance we are looking at the Invoice Summary No Body part layout in the exercise file. Our output is going to look like a column that has the customers and the other column shows the total invoice sales for whatever the time period is reflected in the found set. The report represents the correct data but a SubSummary report only displays subgroups as rows in a list. So a more convenient output format for most users would be what a lot of people refer to as a Crosstab report or a lot of people imagine when they think of a pivot table. A Crosstab report presents a summary of information both rows and columns, so you can see sort of the intersection of a row and the column will mean a specific piece of information. In this format it's much easier to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.