Don't you really have more than two tables?
Seems like you need both a table for appointments and a table for sales.
Even if you are only selling big ticket items like houses or such, I would think that you don't have a one to one relationship between appointments and items sold. (Might there be more than one appointment before the item is sold?)
This sounds like a classic problem that results in people complaining: "Why doesn't FileMaker support Left Outer Joins?" If we could set that up on a layout, this would be easy to do.
One option to work around this is to add a portal to appointments sized many rows tall, but set to "slide up", "Resize enclosing part". This gives you a portal that shrinks down to just the rows needed for a given contact when you print, preview or save as PDF.
Another option is to add one dummy appointment record for every contact that lacks any appointment records. A number field in appointments that has data in records for actual appointments but does not have data in this "dummy" record can be counted to give you a count of appointments while still allowing you to list contacts that do not have any appointment.
Yes, we do have more than one table. The appointment table stores info on the specific appointments including how much a product was sold for and the little details on financing, etc. but we also have a table specifically for jobs we install. We do residential solar energy and other home improvement products, so there's a bunch of details in that table. The table I need to pull information from is mostly the appointments table, but I need a count of the total contacts we have to get a percentage of how many we set appointments with out of that. That's literally the only information I need from that table is how many total contacts we have.
If all of the data you need for your report is in contacts and appointments, I don't read anything in your last post that changes my previous suggestions.
Well, this report only uses the sub-summary layout parts because it's basically showing sales by office and zip code and summarizing the gross sales, net sales, cancels, etc. I don't actually want to view any of the individual appointment or contact records. Created dummies won't work because our system is setup so that before a contact has an appointment created it is set to a different status and will only show in a certain part of the system - if I setup an appointment it will change this status and show up in the leads section instead of contacts. Can't have that because it will cause confusion for the database users.
I think you need either those dummy records--what you describe does not make that option impossible or a separate reporting table into which you import just the records you need for your report. That would make the "dummies" records in a table separate from appointments.