Sum per page in report builder 6i

[nouf]

hi..
how can i put the sum of salary in the report accumulated. means the first page contains the sum of all salaries in the page and the second page contains the sum of all salaries of the first and the second page and so on..

 

[nagornyi]

You need to create 3 columns of the report level:
CS_1 is sum of the salary reset on Page
CP_1 is placeholder of Number type. Set Value if Null property for CP_1 to 0.
CF_1 is formula column of Number type with the following text:

function CF_1Formula return Number is
begin
  :cp_1 := :cp_1 + :cs_1;
  return :cp_1;
end;

Now if you draw a field and source it with CF_1, the field will display aggregated totals per page.