AnsweredAssumed Answered

Report grouping

Question asked by MichaelHokanson on Mar 3, 2014
Latest reply on Mar 3, 2014 by philmodjunk


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.