I have developed a report that groups by a field called "Job" and in the details section includes a field called "OpService". The report uses a record selection formula, a group selection formula, and some other formulas that I use to suppress certain detail lines and to highlight those detail lines displayed that are Lee's operations. The report also includes three subreports (one visible and two hidden).

I need to create an additional group that includes all of Lee's operations, so that for each of his operations the report displays all the jobs that include that operation. Everything in the report needs to remain exactly as it is now, but above the job grouping level I need this new grouping level. I have formulas that I use to identify all of Lee's operations; I use them at the group level to select only those jobs that include one or more of Lee's operations and at the details level to highlight Lee's operations. I am trying to figure out how to use one of these formulas to create my new grouping.

I will be glad to provide additional details, as needed, to anyone willing and able to help me.

Thanks in advance for your help!

Matteo