BI Publisher (MOSC)

MOSC Banner

combination of 'IF' condition and 'DECODE' function in TEMPLATE

edited Oct 8, 2009 1:01AM in BI Publisher (MOSC) 1 commentAnswered
 Hi,

I am trying to use a 'decode' function for a conditional region using 'if'. It is not giving me the right results on preview.

<?xdofx: if decode(CF_TRX_TYPE_NAME, 'AAA',’1’, 'BBB',’1’,’2’)=’1’?>

Conditional Formatting worked

<?end  if?>

-- Didn't work

But, decode used seperately without 'if' clause worked.

<?xdofx:decode(CF_TRX_TYPE_NAME, 'AAA',’1’, 'BBB',’1’,’2’)=’1’?>

--Worked

Can somebody help?

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