Summary Count (uniques?)
FMP 12, Server 12, running on a Windows 7 environment.
Data base has:
One table is DRF records (a project document). The DRF number is a serial number issued by FMP with uniqueness enforced.
Another table is for production items, which fall under project numbers (DRF numbers). The DRF number is entered into a field in every item under that DRF, and some fields are either placed onto layouts in the Items table, or looked up from the DRF by the Item. One other field in each Item is the OPCO (operating company owning the project – tightly controlled by a drop down list to support relationships).
I have a summary report layout showing projects and items (in the Items table), sorted by Operating Company, Project Number (as entered in the Item record), and, in the body, the code numbers of the items.
I have a summary count field in the sub summary part, showing the number of items in each DRF, and a grand total at the end. All good so far.
I have been asked to show a count of the DRF numbers (how many unique DRFs represented), which display in the sub-summary part which is sorted by this DRF Number. I can’t figure out how to show the number of unique DRF numbers, the field always returns either 1, or the total number of items. I have tried creating the field in the both tables, and placing it on various parts, but can’t get it to work. I have a hunch that if I took out the body, it might work, but I need the body to be in the report.
I’m not real experienced in reports, so quite possible I’m overlooking something. I hope I have explained this well enough.
Any help out there?