BI Publisher (MOSC)

MOSC Banner

How to use like condition within IF-ELSE condition in RTF/BI Publisher

Hello Folks,

Can somebody please help me with below requirements to achieve.


I want to display heading value as null in report if below condition does meet the criteria else 'Gross Units'.


While using like condition it does not work


Approach#1

<?xdofx:if (g4_Title_RULE like '%First%Title%Desc%' or Q4_ROYALTY_EARNINGS_RULE like '%Second%Title%Desc%')  

then ''

 else

'Gross Units'

end if?>


Approach#2

<?xdofx:if (@row:starts-with(Q4_ROYALTY_EARNINGS_RULE,'Multi') or @row:starts-with(Q4_ROYALTY_EARNINGS_RULE,'Single '))

 then ''

 else

  'Gross Units'

end if?>


Thanks in advance, please as soon possible, requirement is quite critical.

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