Report Grouping doesn't work after using Find feature in FM Pro 12
Posted on 2013-01-05
I am an Access DB programmer working w/ my first FileMaker Pro project and working through the typical growing pains of a different software methodology.
I have a FileMaker Pro 12 DB w/ a home winemaking application and a One-Many relationship between a Batch number and vessel number where One batch has many vessels. The DB works fine however when I create a new layout based on a Report, select the given fields, it works fine the first time I run the report. The report groups on Batch number, shows all the vessels (carboys/jugs) and breaks on the next batch number. The Edit mode confirms it very similar to MS Access.
When I choose FIND, select a boolean, "Transfered" Yes/No and rerun the report, it consolidates the report into one w/o grouping. After removing the filter (find) it no longer groups the report. I have created 3 similar reports; all do the same. After closing the program; reopen it maintains the last report w/o any grouping.
How is this so?
Any help would be appreciated.