jasper reports - ireport quires set for the SQL for Set query?

Question

I am trying to get equivalent query for the Ireport. this is my sql query. but when I am pasting it to Ireport dataset i am getting this error.

set @csum := 0;
set @csum1 := 0;
select SUM,(@csum := @csum + Profit_Total) as Cumulative,
Sum(profit) as Profit_Total
from table t1;

Answer 1

You can try in this way, first try to set the variables in inner select statement then you can sum up in the outer select statement :-

    SELECT SUM(@csum := @csum + Profit_Total)
    FROM (SELECT profit, @csum := 0
          FROM  t1) a;