>>Try this SQL to process the detail records:
>>
>>Select Name,Round(Sum(Sal),0) As Sal ;
>> From Salary ;
>> Group by name
>
>John, thank you for reply.
>
>My problem is that I have a ready finished program and
>I need to send new report to program users.
>
>I can only change the report. This is FoxPro for Windows report,
>so code cannot be attached. It is possible to call some external
>fxp from report, but this cannot change report control table.
>
>A big database is opened before report and filter are set to it.
>I am capable to change a report only or to call external fxps inside
>report.

Inaddition to what Dragan said...
You could put a function call in your title band so it only gets called once. This function would summarise using SQL the amounts and put the results into a cursor. You then SET a RELATION from the report file to your new summary file. And just for safety, reselect the original table.
You can then reference the summary fields automatically for the rest of the report.
In the summary band of the report (which i think is called last) you can clear the relation and delete the cursor by calling another function.
HTH