From Dwayne Wright PMP
Certified FileMaker Developer
Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit. For the best experience, please visit the journal directly by clicking (here).
This is a fairly simple report that comes up in the new window. We only have two data fields which include an invoice date and an invoice amount. What we want to do is show a report that summarizes the invoice sales for each year and then further broken down by the month of the year. The report will run on the found set of records. So you can do a find for a particular set of records and then run the report.
There are two sorted by subsummary layout parts the sort fields uses are both calculation fields. The first is year of the sale and the second is the month of the sale. There is a script that runs the report in a new window and a subscript that handles the report printout actions.
Clicking the Run Report button will activate the report. You might want to have the script debugger running if you have FileMaker Advanced installed on your machine. That will allow you to see the individual script steps execute one at a time from the script debugger window.
An example file can be downloaded by clicking (here)
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.