February 10, 2014

RTF Template -- Repalcing Zero values with blank in BI Publisher



RTF template replacing zero values with blank space:
Here I have a requirement to replace zero values with blank space.
I have to do in RTF template level.
To resolve this issue I used decode function in RTF template.
You can find below screen shot which having zero values.








Open column properties of each and every column.







And modify the column formula in advanced tab as shown below.(you have to change column name for other columns)






Below is the result after changing the formula in each and every column.


Posted by at
Labels:

4 comments:

  1. MuheethJanuary 20, 2021 at 1:13 PM

    throws oracle.xdo.XDOException: oracle.xdo11g.xqxp.XQException: XPTY0004
    at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1300)
    at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:308)
    at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:2110)
    at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1213)
    at RTF2PDF2.runRTFto(RTF2PDF2.java:484)
    at RTF2PDF2.runXDO(RTF2PDF2.java:343)
    at RTF2PDF2.main(RTF2PDF2.java:235)
    Caused by: oracle.xdo11g.xqxp.XQException: XPTY0004

    ReplyDelete
    Replies
    1. RajuJanuary 29, 2022 at 8:08 PM

      Hi Muheeth,

      Is your issue resolved ??

      Thanks,
      Naga.

      Delete
  2. velaePbist-nApril 24, 2022 at 8:40 PM

    velaePbist-n Kim Lopez https://wakelet.com/wake/TagVdxR0Ehw0eT4C1XY1K
    ovviemota

    ReplyDelete
  3. quiplacscep-na1992December 1, 2022 at 11:54 AM

    0misaldes_wa Cyndi Peacock Awesome
    Awesome
    kizrisoper

    ReplyDelete

Subscribe to: Post Comments (Atom)