why don't you make the sum of the colums in another procedure
or if it is too complicated do it in the same procedure like this (this is
only an ideea )
my procedure ...
return SumOfColumn1,SumOfColumn2,SumOfColumn3....
as
begin
for select xxx
into xxx
do begin
SumOfColumn1=SumOfColumn1+xxx;
suspend;
end
/*now you return the last sum of the columns wich you can find it with the
Query.Last*/
end

At 19:50 20.02.2001 +0100, you wrote:

>Hi all,
>
> Maybe this is a silly question, but I can't help it, I don't know
> how to do
>it. The problem is the following :
>I have a stored procedure that is returning let's say 10 rows, and looks
>something like this :
>
> AText1 10 11 12
> AText2 13 14 15
> AText3 16 17 18 .......
>
>Most of all is numeric data. My question now is : I would like to make the
>sum of each column. I tried with a calculated field (I make the sum in the
>OnCalculateField event), but when I move the record pointer, the sum is
>changing according to how far the recordpointer is in the result set. If
>the recordpointer is in the last record, it shows the whole sum, otherwise
>only the sum is shown until where is the recordpointer.
>
>Any help is highly appreciated,
>Many regards,
>
>Nico Callewaert
>
>nico.callewaert@...
>
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>