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 perform comparative analyses and…
Author
Released
3/19/2013- Managing access to your database
- Parsing text with calculation functions
- Using calculations in field validation and auto enter options
- Creating nested subsummary and crosstab reports
- Creating user-driven and multi-criteria relationships
- Working with intermediate script techniques
- Extending Web Viewer using HTML5 and data URLs
- Sharing databases on a network using FileMaker Server
- Publishing your databases to the web using the Instant Web Publishing or PHP
Skill Level Advanced
Duration
Views
Related Courses
-
FileMaker Pro 12 Essential Training
with Cris Ippolite10h 28m Beginner -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome46s
-
-
1. Managing Access to Your Database
-
Creating accounts6m 25s
-
Customizing privilege sets9m 30s
-
Applying extended privileges4m 45s
-
-
2. Calculations: Extending Text Functions
-
Parsing lists of values9m 55s
-
3. Calculations: Logical Functions
-
4. Other Uses of the Calculation Dialog
-
5. Calculations: Working with Aggregate Functions
-
6. Advanced Reporting Options
-
Reviewing subsummary reports6m 10s
-
Creating a crosstab report14m 32s
-
-
7. Extending FileMaker Relationships
-
8. Scripting for Developers
-
The Set Field script step5m 28s
-
Working with script variables10m 31s
-
Setting script parameters3m 12s
-
9. Extending Web Viewer
-
Using HTML5 in the Web Viewer10m 27s
-
10. Sharing Your Databases on the Network
-
Best practices5m 37s
-
Configuring FileMaker Server13m 52s
-
Scheduling backups7m 23s
-
11. Web Publishing: PHP and Instant Web Publishing
-
Preparing your files for IWP6m 24s
-
Touring the IWP interface6m 51s
-
Design considerations in IWP8m 48s
-
Scripting in IWP8m 37s
-
Setting up your file for PHP6m 25s
-
Conclusion
-
Goodbye54s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a crosstab report