Report Grouping doesn't work after using Find feature in FM Pro 12

Hi Experts:
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.
regards,
dwcorwith
LVL 2
dwcorwithAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Will LovingConnect With a Mentor PresidentCommented:
Sub-summary grouping in FileMaker requires that the records be sorted. You can do this manually (Control or Command - S) or via a script step with a saved sort parameter. There is a checkbox in the Sort dialog that says "Keep records in sorted order", but this only affects records that are already sorted and changes to records such as editing or adding a new record.

If you perform a different Find or close and re-open the file such that the original sort order is lost, you will need a mechanism to perform the initial sort. One way to do this is to create a script that includes the "Sort Records" step with the desired Sort Order. Then use a Layout Script Trigger which can be found under Layout Setup, the fourth tab, "Script Triggers". You could use "OnLayoutEnter" to have the records sort when you initially go to the layout or "OnModeExit" (enabling just in "Find" mode), so that when the user exits find mode, it will run the designated Sort script.

OnModeExit Script Trigger
0
 
dwcorwithAuthor Commented:
Willmcn,
Thanks for the detailed response.  That worked.  From another thread I used to resolve:

Standard FileMaker behavior.

Grouping requires that the records be sorted by the "group" field--the field that has the same value for all members of a group.

Performing a find produces an Unsorted found set.

You then need to sort your records again by the group field--it won't happen automatically.
0
 
Will LovingPresidentCommented:
Just for future reference, while you can list a question for any number of points you want, in practice, nearly all questions are listed at 500. Lesser point amounts may slow or reduce the number of responses you get.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.