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]