Join Cris Ippolite for an in-depth discussion in this video Creating subsummary reports, part of FileMaker Pro 13 Essential Training.
…Creating reports out of the data in your FileMaker database…is going to be a very common request that you'll get.…And adding a summary field to a list view…can turn a static list of data into a somewhat…more compelling report by simply showing the user some aggregated…data that didn't have to be entered into the database.…As a matter of fact, you can that here.…We've got a summary field called total summary…that is totaling up all of the invoice…total fields and if we changed our found…sets, that value gets updated per each found set.…
Now many times large list views can still be tough to interpret.…But a good method for making them more intuitive is to…group the data into little separate mini found sets, or grouped data.…You can break this down into data that can be easier to…consume, and easier to review if you're creating a report, for example.…FileMaker has a special layout part that's called a sub summary part.…That you can use to give your layout…instructions on how to group data in a list.…This, in essence, creates these little mini-found sets of…
Author
Released
5/7/2014- Creating databases from Starter Solutions
- Determining what tables you need
- Defining key fields and creating relationships between tables
- Creating fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Managing layouts and layout objects
- Using the Layout Assistant
- Applying themes to layouts
- Finding records and working with found sets
- Building reports and charts
- Exploring calculations
- Creating and triggering scripts
- Working with relationships in scripts, calculations, and charts
Skill Level Beginner
Duration
Views
Related Courses
-
FileMaker 13 New Features
with Cris Ippolite3h 56m Appropriate for all -
FileMaker Pro: Relational Database Design (2011)
with Cris Ippolite2h 40m Intermediate -
Learning FileMaker Go
with Cris Ippolite1h 15m Appropriate for all -
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced
-
Introduction
-
Welcome1m 1s
-
Using the exercise files1m 29s
-
-
1. Getting Started
-
What is a database?2m 33s
-
Exploring the interface6m 17s
-
-
2. Database-Creation Essentials
-
Adding tables by importing5m 52s
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 34s
-
5. Working with Fields
-
Understanding field types5m 12s
-
Defining fields8m 32s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records4m 35s
-
8. Importing and Exporting
-
Importing data9m 50s
-
Exporting data5m 42s
-
-
9. Creating Layouts
-
Introducing layouts4m 1s
-
-
10. Working with Layouts
-
Previewing the Inspector1m 39s
-
11. Formatting Layout Objects
-
Applying Screen Stencils3m 25s
-
Applying gradients2m 19s
-
Understanding states5m 9s
-
Setting field behaviors3m 23s
-
Using the popover feature7m 40s
-
Setting the tab order4m 29s
-
12. Finding Data
-
Saving find requests6m 15s
-
13. Sorting Data
-
Sorting with related fields2m 21s
-
Sorting using custom values3m 44s
-
Sorting using buttons4m 54s
-
14. Value Lists
-
15. Printing and Saving
-
Printing in different views6m 15s
-
Printing merge letters5m 24s
-
16. Reports
-
Creating subsummary reports8m 29s
-
Adding charts to reports9m 10s
-
17. Calculation Essentials
-
Introducing calculations3m 11s
-
Using number functions6m 12s
-
Using text functions9m 5s
-
Using get functions3m 58s
-
Using logic functions9m 50s
-
-
18. Script Essentials
-
Creating multiline scripts10m 23s
-
Using script parameters5m 7s
-
19. Script Triggers
-
Introducing script triggers2m 13s
-
Using object-based triggers13m 5s
-
-
20. Using Relationships
-
Using related fields8m 10s
-
Creating portals7m 48s
-
Conclusion
-
Goodbye1m 49s
-
- 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 subsummary reports