I finally got this working by using this :
<?If:CERT_NAME_P = ''?>All<?end if?> <?If:CERT_NAME_P != ''?><?CERT_NAME_P?><?end if?>
Categories
- All Categories
- 118 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 48 Oracle Analytics Trainings
- 6 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 7 Oracle Analytics Industry
- Find Partners
- For Partners
Parameters in Layout If Statement Not Working

So I have a multi-select parameter that returns null when All is selected.
I am printing my parameters to my RTF layout.
I have tried:
<?if@notEmpty:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?>
<?if@inlist:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?>
I get an error like this most of the time
<Line 42, Column 72>: XML-22013: (Error) Error in expression: './/{CERT_NAME_P}'.
The closest thing I've gotten to work is
<?if@section CERT_NAME_P?><?CERT_NAME_P?><?else?>All<?end?>
It returns All if All is provided which is good
When on item is selected it looks like this:
Selection1All
I would expect the All to go away but it's added to the end.
If I select two options it looks like this:
[Selection1,Selection2]All
Just adding for context
Best Answer
-
I finally got this working by using this :
<?If:CERT_NAME_P = ''?>All<?end if?> <?If:CERT_NAME_P != ''?><?CERT_NAME_P?><?end if?>
2
Answers
-
Very helpful information.
Thanks for sharing @User_9ZFXH!
1