Hello community, I commented to you the problem that I have, I am generating a report of debts of clients with the following query:
SELECT
COALESCE(sum(F.total),0) AS Compra,
CC.saldo - sum(F.total) AS deuda,
C."razon_social" AS cliente,
CC."saldo" AS saldo
FROM
"public"."factura" F INNER JOIN "public"."cliente" C ON F."uncliente_id_cliente" = C."id_cliente"
INNER JOIN "public"."ctacte" CC ON C."razon_social" = CC."razonsocial"
WHERE
F.fecha >= $P{fechaInicial} AND F.fecha <= $P{fechaFinal}
GROUP BY
razon_social,
saldo
The problem is that, as you will see in the condition an initial and final date is requested, that is to say a range, my problem is that if there is no invoice issued in that range the jasper returns DOCUMENT HAS NOT PAGES, but I I need you to generate it for me! Does anyone have any idea how to do it? Thank you very much