Código SQL [-]SELECT FECHA ,SUM(TOTAL) AS TOTALVENTA ,SUM( CASE WHEN IVA > 0 THEN TOTAL ELSE 0 END ) AS TOTALCIVA ,SUM(IVA) AS TOTALIVA FROM Ventas GROUP BY FECHA
SELECT FECHA ,SUM(TOTAL) AS TOTALVENTA ,SUM( CASE WHEN IVA > 0 THEN TOTAL ELSE 0 END ) AS TOTALCIVA ,SUM(IVA) AS TOTALIVA FROM Ventas GROUP BY FECHA