[Solved] ireport quires set for the SQL for Set query?
[ad_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; 0 [ad_2] solved ireport quires set for the SQL for Set query?