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

by


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

solved ireport quires set for the SQL for Set query?