Sum

valdemirjs

How to do this report without using the resource crosstab??

ID Name Value 1 Value 2 Value 3 Total
001 Jos?© 100 150 70 320 --> and here??
002 Manoel 200 50 30 280
003 Maria 300 30 40 370
Total (here I use sum) 600 230 140

Nack

Well, I do not really understand your trouble.
What do you want to do ?
Calculate all the different sum ?
Or is it the way to design your report, but what kind of data do you have ?

basswar

Dou You mean that You wanna sum the 3 columns in the last column and sum all the numeric fields in the report summary (or anywhere)? You can simply put an expression in the memo representing the row_total. [Value_1+Value_2+Value_3] put this code in the OBP event handler and assign this result value to a variable.
for ex.:
ROW_TOTAL:=Value_1+Value_2+Value_3; Display this ROW_TOTAL variable in the memo and the final summing at the end of the report will be easier because You can write there : [SUM(ROW_TOTAL)].

Regards:Alex