Result my query no show after build project, Works in the query editor but it doesn't show on the

Hi
result expected ! Works in the query editor, but it doesn't show on the generated pages

Resulto
-, DATA, 'LIQUIDO','LIQUIDO'-

SELECT
SUM(VALOR) AS valor,
DATA,
ESPECIE,

CASE
WHEN (TIPO = 'SANGRIA') THEN 'SANGRIA'
WHEN (TIPO = 'SUPRIMENTO') THEN 'SUPRIMENTO'
WHEN (TIPO NOT like '%SANGRIA%' AND TIPO NOT LIKE '%SUPRIMENTO%') then especie
END AS NOVA

FROM MOV_OPERADORES
WHERE (VALOR > 0) AND (DATA >= cast('Now' as date) - 4)
GROUP BY 2, 3 , 4
UNION ALL
SELECT (
SELECT SUM(VALOR)
FROM MOV_OPERADORES
WHERE (VALOR > 0) AND (DATA >= cast('Now' as date) - 4)
AND (
(ESPECIE IN ('DINHEIRO') AND TIPO NOT IN ('SANGRIA','SUPRIMENTO')) OR
(TIPO IN ('SUPRIMENTO'))
)
) - (
SELECT SUM(VALOR)

FROM MOV_OPERADORES
WHERE (VALOR > 0) AND (DATA >= cast('Now' as date) - 4)
AND (
(ESPECIE IN ('DINHEIRO') AND TIPO IN ('SANGRIA')) OR
(ESPECIE IN ('TROCO'))
)
), DATA, 'LIQUIDO','LIQUIDO'
FROM MOV_OPERADORES
WHERE (VALOR > 0) AND (DATA >= cast('Now' as date) - 4 )
AND (
(ESPECIE IN ('DINHEIRO') AND TIPO NOT IN ('SANGRIA','SUPRIMENTO')) OR
(TIPO IN ('SUPRIMENTO'))
)
GROUP BY 1, 2, 3 , 4

thanks in advanced