Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-01-05
3
Medium Priority
?
570 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

671 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