printing would be a big issue for #2, but if you export the HTML then it would work fine.
#1 is the way to go for complete control in gathering your data, and can be used to feed your table in #2 as well. This technique is called the "virtual list" technique. Seedcode has a good demo on this technique: http://www.seedcode.com/virtual-list/
This technique would allow you to conditionally format your "cells" (fields) in filemaker as well to match the formatting in your picture above.
oh, and use virtual lists, using repeating fields creates an ungodly amount of overhead. virtual lists keep your data in memory, and calculate out each cell with simple calculations like:
GetValue($$virtualData ; Get(RecordNumber) )
All good suggestions by Mike; I'm partial to building simple HTML tables from a looping script, because it's relatively straightforward, and lets you do nice stuff like this:
(Imagine some fancy CSS added so it's really nice … and be aware that you need to cater for null values to prevent misalignment.
To manage multiple users within the same virtual list table, add a field for userID / accountName / otherDistinguishingFeature, and have the script take that into account.
HTML approach is great, and you can likely do this without it as well. The table you're showing would be more of a summary table. There would be a second table that holds the actual data in line item form. On the summary table, under the layout scheme you illustrated, the zone headers would be global text fields with drop down menus. The table itself would hold has many or as few of the types you would want to print. The fields showing the number of sites would be calculated fields. The calculated values would reference the values in the zone headers and the site types field, and use that to summarizes data held in a second table. That second table would have at least the following 3 essential fields: Zone, Type, and a Site Count.
That's all assuming I'm understanding your question correctly, but it seems quiet possible to do what you're proposing with a total of 2 tables, no repeating fields.
Hello, Peter. HTML, Virtual List both great ideas and methods I've used. You might research 'cross tab reporting' with FileMaker. This forum and others can point you to other methods.
Here are some links to get you started:
So many good ideas.
Thanks everyone. I will explore all of the techniques provided here.