Solved

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

Posted on 2013-01-05
3
546 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 24

Accepted Solution

by:
Will Loving earned 250 total points
Comment Utility
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
Comment Utility
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 24

Expert Comment

by:Will Loving
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now