Subject | Stored Proc question |
---|---|

Author | Nico Callewaert |

Post date | 2001-02-20T18:50:39Z |

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]

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]