Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-01-05
3
Medium Priority
?
574 Views
Last Modified: 2013-01-08
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
0
Comment
Question by:dwcorwith
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 1000 total points
ID: 38752415
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
 
LVL 2

Author Comment

by:dwcorwith
ID: 38757506
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
 
LVL 25

Expert Comment

by:Will Loving
ID: 38757559
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question