Fórum Xmaker • Soma condicional em Relatório

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 594: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 650: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1110: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1110: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1110: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5277: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5277: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5277: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3903)
Fórum Xmaker • Soma condicional em Relatório

Página 1 de 1

Soma condicional em Relatório

Enviado: Agosto 8th, 2017, 5:13 pm

por andrec

Alguém sabe como fazer uma soma condicional em relatório?
Sabem se é possível com a versão do FreeReport que acompanha o Xmaker?

Eu estava tentando algo do tipo:

[SUM(IF(DCONTAS."TIP_DESCRICAO" = 'BOLETO', [DCONTAS."CON_VALOR"], 0))]

A intenção era fazer no sumário do relatório um resumo dos totais por forma de pagamento.

É possível fazer uma soma condicional no FreeReport, seja por uma expressão ou mesmo via script?

Agradeço desde já a ajuda...