I want to display negative values in a SQLCOL column with a F1-DE-SINGLE based zone. Whatever I'm trying, it seems that the system rounds negative values to 0 (result is correct when running the sql query by it self).
At the end I tried a very basic test :
, (select (-1) from dual "QTE")
Column definition :
source=SQLCOL sqlcol=QTE label='QTE'
The column displays : 0,00
Does anyone has a clue of what's hapenning and of a solution for this ?
may be a stupid questions ;) did you check your SQL in SQL developer or toad to check if it gives your desired result ?
if yes, try to display a value from your zone without any formatting(like adding a type), even if that fails I can imagine it should be some sort of compatibility issue with your SQL and zone. Why not re-writing your SQL in different way.