Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Parameters in Layout If Statement Not Working

Accepted answer
11
Views
2
Comments

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: &#39;.//{CERT_NAME_P}&#39;.

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

  • Rank 3 - Community Apprentice
    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?>

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.