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
Solved

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

Posted on 2013-01-05
3
556 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 250 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sync a Wordpress with Filemaker 9 536
PDF In Filemaker GO 3 1,132
FM Exporting Pictures In Container 1 1,032
FM Pro Lagging and shows a blue spinning circle?? 2 56
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…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

829 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