7 Replies Latest reply: May 21, 2013 4:30 AM by Fabien D. RSS

    How to display negative numbers with a F1-DE-SINGLE zone

    Fabien D.
      Hello,

      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 :

      Query:
      select...
      , (select (-1) from dual "QTE")
      ...
      from...


      Column definition :

      source=SQLCOL sqlcol=QTE label='QTE'
      type=number

      The column displays : 0,00

      Does anyone has a clue of what's hapenning and of a solution for this ?

      Thanks,

      Fabien