Firebird 5.0 with FastReport (Delphi 12): unknown ISC error 0

[TheBioh4z4rdx 0]

When I execute a simple "SQL" with frxDBXQuery within Fast Report, using "SUM" : Unknow ISC error 0
If I remove the "SUM" the "SQL" query works...

 

Quote

SELECT NF.DOCUMENT, SUM(NF.TOTAL) AS TOTAL FROM NF

 

Pls help me 😞

[Stano 143]

The GROUP BY NF.DOCUMENT part is missing

[Stano 143]

For compiling SQL texts I recommend to use some DB manager. It would print this error directly!