how to sum up all raws values in last columns and sum up all column va

[ub1234567]

Hi everybody,

i want to sum up all column vlaues at last - bottom of column and su up of one tuple - raws values in last column.

i want to handle this in my query and function not at crystal side.

below is my sample output :

column 1 column 2 column 3 sum

raw 1 10 15 5 30

raw 2 5 7 3 15

raw 3 2 4 6 12

total 17 26 14 57

at raw level calculation i m using functions in package.

so my question is that using function in package how can i sum up all and display in ast column and at bottm of each column.

i am stuck at this point.

thanks.

any help is greatly appreciated.

 

[IanWaterman]

If you use a Cross tab Crystal will do this automatically for you.

Ian