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;
See Question&Answers more detail:os