BI Publisher (MOSC)

MOSC Banner

If else condition using BI Publisher RTF

edited Jul 25, 2019 5:05AM in BI Publisher (MOSC) 1 commentAnswered

I have a report to create requested by the user, now my problem is I was stuck while creating it in an RTF template. Because I have a two columns that contains different value. For example, I have a table that contains a value. Please see below.

<span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">Item_Number     Discount      Number1       Number2 <br/>Item1           500           145           156</span>

Then I want in the report that when the discount is greater than 0, it will returned the column Number1else Number2

I tried <?xdofx:if DISCOUNT < 0 then ‘Number1’ else 'Number2' end if?>

but I returned the value of the 3 columns. I tried also to removed the apostrophe but I returned the same value.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center