Set up 2 layouts just for these 2 reports.
Remove the body layout part and replace it with a sub summary layout part. Select Equip_ID as the "when sorted by" field. Put the fields you want to see in this sub summary layout part. Sort your records by Equip_ID and this sub summary layout part will be visible and you'll get one row of data for each Equipment ID.
Do the same, but add a sub summary layout part and specify Location as the When sorted by field. Sort your records with a sort order that sorts them first by Equipment ID and then by location.
For more on summary reports: Creating Filemaker Pro summary reports--Tutorial
Using a sub-summary report was the first method I tried however, this doesn't address the issue of displaying only single instances of duplicate Equip_IDs for each Location in a given time period.
It will only display a single instance of every Equip_ID in that time period. Because almost each Equip_ID has multiple tests from the same Location, this will just display almost everything.
I believe it's the same with the Location version.
I appreciate the response, though! Thank you!
A sub summary layout part "when sorted by Equip_IDs"
can be used for this purpose if you sort by location, then by equipment ID. You'll get one row of data for every item of equipment tested at each location.
I've originally tried this as a sub-summary report, and when this was suggested on another filemaker forum, I just accepted this as the answer.
The problem is, even when I narrow it down to one date range and use the sub-summary report, I still get thousands and thousands of rows to sift through, before I find the one Equip_ID with multiple stores.
It kind of looks like this, only with thousands of rows to scroll before I find the Equip_ID with multiple Locations for the date range;
To repeat from an earlier post, Just keep the sub summary layout part. Delete the Body layout part and you won't get thousands of rows of data.You'll get just the sub summary rows.