Roi,
>
>Thanks for the help. Sounds like a good plan, however, I simplified my example and there is a 3rd group under Project called Job. I can print the summaries in the detail band. They have to be in the project footer. Putting them in the detail would put the same Project summary under each job.
>
Can't you use print when to avoid the project summary from printing again? IOW, put projectID <> "ZZZ" in the "Print When" expression.
>I was thinking of building the summaries manually and putting them in a memo field. Every row in the cursor with (project = x) would have the project summary and then printing the memo in the project footer.
>
Create the summaries with a SQL-Select, then SCAN/ENDSCAN to populate the memo fields? That would work...
>That is going to be a PITA, I was hoping there was an easier way.
>
I know you simplified your example, but I still think you could do by putting the summary information in records in the report cursor. But you've probably got this problem licked and moved on to better things *smile*
Steve Gibson