[Solved] ireport quires set for the SQL for Set query?

by

[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?