- slide 1 of 13
How FileMaker Forms and Reports are Similar to MS Access
MS Access users know that forms and reports are the database objects that access, control and display the information in their database. FileMaker Pro 10 for Windows (hereinafter referred to as FileMaker) uses somewhat the same approach, except it employs the layout view that serves both as a data entry form and reports display.
Also, as in MS Access, the user can create the layout from scratch, or, as demonstrated in this article, use a handy wizard to create a specially designed layout. Experienced MS Access users will have no difficulty with the FileMaker layout wizard. Follow the steps the in this article to see how the wizard works to create a grouped report.
- slide 3 of 13
Do the Wizard Steps:
Step 1 - Create a new layout/report while the database is in Layout (design) view. The key is to select the table where the records reside. Our example screenshot is from a sample FileMaker database that has a table called “Sales by Area." Follow the steps in the screenshot below to create a List/Report layout similar to an MS Access grouped report:
- slide 6 of 13
Steps 4 and 5 - Select how your records will be grouped. In our screenshot examples, we have chosen the sales Area field as our grouping field. In Step 5, we have chosen the Salesmen field to be sorted within the Area field.
- slide 8 of 13
Steps 6 and 7 - In order to make our sales totals add for each Area, as well as to get our grand total at the end of the report, follow the examples in the two screenshots below.
- slide 10 of 13
Steps 8 thorugh 10 - These are the last optional steps to add the finishing touches to our layouts. In our screenshots we have chosen a colorful blue layout, added a header and footer, and have opted not to include a script to the report at this time.
- slide 12 of 13
The "Semi-Final" Product
Now that your grouped report/layout has been generated, it is ready for tweaking. For example, we can align the number fields, format them to currency with two decimals, and even add subgroupings within our sales personnel to calculate their individual sales. We do this by changing our view from Browse to Layout (click on the Edit Layout button in the far upper right of the browse window). Techniques for making layout changes will be covered in an upcoming Bright Hub article.
FileMaker Pro 10 for Windows: Creating Layouts and Reports
FileMaker Pro 10 for Windows is a database design application that works on the Windows and Mac computers. Microsoft Access users will have no difficulty learning FileMaker and will quickly learn to create robust database applications. This series presents FileMaker basics, from fields to layouts.