BI Publisher (MOSC)

MOSC Banner

Issues creating condition

I'm new to BI and have had no formal training, so I'm looking for assistance in determining how to resolve a couple conditions.

I've attempted (2) different paths to meet my requirement.

Requirement is If TORG = User IDxxx print Namexxx

or if TORG = User IDxx1 print Namexx1

else

Namexx2


Option (1): Using an IF statement vs. Option (2) below:

I pulled the field into the template. Double clicked on the field and on the Advanced tab created the following statement:

I've tried a ' around the name with no change. Nothing displays based on the below. I would like to build on this to include an OR statement once the below is resolved.

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