SELECT IN REPORTS25

From: (wrong string) ínio <Conceicao.Sousa_at_atm.mailcom.pt>
Date: Fri, 15 May 1998 10:50:22 +0100
Message-ID: <355C0FDE.330A_at_atm.mailcom.pt>

[Quoted] Can SomeOne Explain to me why does the Following query works in Sql*plus and does not work in
reports25?

Select Sum(Nvl(Feder,0)) valor_feder From (Select Nvl(Valor_Feder,0) Feder
From rime_pagamento pag, rime_promotor pr where pag.cod_projecto = pr.cod_projecto and pag.regiao = pr.regiao and
pag.ano = pr.ano and
pr.cod_ea = 'BPA' and
(pag.data_pag <= '98.05.15' and
(activo = 'S' or activo is null))

UNION
Select Nvl(Valor_Feder,0) Feder
From rime_pagamento pag, rime_promotor pr where pag.cod_projecto = pr.cod_projecto and pag.regiao = pr.regiao and
pag.ano = pr.ano and
pr.cod_ea = 'BTA' and
(pag.data_pag <= '98.12.31' and

activo = 'N' ));

Giving me the following error message:
Error 103
Encontered the symbol "(" when expecting one of the following: < a double-quoted string>
Fatal syntax error, unable to recover. Received on Fri May 15 1998 - 11:50:22 CEST