1 Reply Latest reply on Mar 3, 2014 1:44 PM by philmodjunk

    Report grouping



      Report grouping


           I'm trying to support a rather complicated FileMaker solution. and have been asked to create a report that is an aggregate of seven found sets. I have to break them into their individual found sets on the report and cannot figure out how to do that. Unfortunately, the way we are running the find is by searching a field with a lot of data in it, looking for any occurrence of the keyword, so I can't sort on that field. Does anyone have any advice on how to do this report? If I were generating this via SQL I'd copy the data into a temp table, create a flag to identify which term is found in the data, then sort on the flag. I don't need the data stored for every record, so I'm hesitant to add a permanent flag just for this one report.

        • 1. Re: Report grouping

               Copying the data to a temp table is still an option though you won't create a table as part of the script. After finding a set of records, you could use import data to copy that data to a table specified for your report. That might be a useful way to set this up if the same record might need to be listed in more than one found set.

               Alternatively, the script could just use Import Records to copy over the Primary key and then a relationship can match the report records to the records in the original table.

               And I'd use Replace field contents to set a field to a common value for each such found set so that I can sort on that field to group them in the report by keyword.

               If a record cannot ever be part of more than one found set, you could just add a single field to update via replace field contents for grouping purposes on your current table. You may not want to do that, but it works and adding special purpose fields in FileMaker is often necessary.

               Another alternative that may or may not work is to use Save Records as PDF to produce a PDF of your report. There's an append option with that script step that lets you append records to an existing PDF so you could perform a find for the first keyword, save as PDF, Perform a find for the next keyword, append its PDF to the first and so on... The main detail besides getting a PDF of the final report is that each appended PDF will start on a new page.