BI Publisher (MOSC)

MOSC Banner

Hide a column in rtf template based on an instr condition

edited Nov 4, 2016 9:43AM in BI Publisher (MOSC) 5 commentsAnswered ✓

Hello,

I was reading the Formatting Column section of the Report Designers guide (4.10.5) and it seems easy enough, just use if@column construct but my requirement is to use the instr function in addition to if@column something like the following:

<?xdofx: if@column:instr(FIELD_NAME, '*')=1?>

<?xdofx: if@cell:instr(FIELD_NAME, '*')=1?>

But this does combination of xdofx and if@column does not seem to work. Instead of acting like an IF statement, all it does is print the outcome of the instr i.e. it prints 1 when the field_name has a matching string or 0 otherwise.

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