1 Reply Latest reply: Apr 24, 2012 3:06 AM by Syed Khawar RSS

    sum function do not work in oracle reports enhanced spreadsheet format

    772017
      we are using oracle reports 10.1.2.3 in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel.First we thought that it may be because of the comma in the number filed.we removed that comma from the filed but t still gives the error "Error in value"
        • 1. Re: sum function do not work in oracle reports enhanced spreadsheet format
          Syed Khawar
          Hi,
          I hope you already solved this problem, I had the same issue after spending an hour I found the workaround, this is just for the guys who experience the same issue. Try to format your number columns either at database level(not via Report builder property palette) with TO_CHAR(...) OR use this Format Mask at Report level to format your numbers -NNNGNNNGNN0D000(negative sign must be there to avoid space in output Excel).

          Hope it helps,

          Regards,
          Syed Khawar