1 Reply Latest reply: Jun 13, 2014 2:47 AM by KKT RSS

    XML Publisher Report

    User788683-Oracle

      I need to change column value on No column to Blank if current value contain of 1.1, 2.1

       

      Example:

       

       

      No                    Description                   Amount

      ==                    =========                 ======

      1                         AAAA                         100.00

      1.1                      BBBB                         200.00

      2                         CCCC                         300.00

      2.1                       DDDD                         400.00

      3                          EEEE                         500.00

       

      After change value to Blank

       

      No                    Description                   Amount

      ==                    =========                 ======

      1                         AAAA                         100.00

                                 BBBB                         200.00

      2                         CCCC                         300.00

                                DDDD                         400.00

      3                          EEEE                         500.00

       

       

      Please advise.

       

      Thank you.

       

      Wilson