BusinessObjects Board

Code for Optional prompts in BO XI R2

Hi,

I know optional prompts are new feature in BO XI R3.
Is there any work around for optional prompts in BO XI R2.
If there is any work around , please let me know the code.

Thanks in advance,
Murali.


muralikotta (BOB member since 2007-05-09)

There’s no workaround for XIR2. :cry:


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Closest you can get is creating LOVs with the ‘ALL’ option.

Search this forum and you’ll find this discussed a few times.


Eric Vallo :us: (BOB member since 2002-08-15)

These 2 Designer’s FAQ entries will help:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

We did manage to get workabout in R2 for Option prompt using the code below.

This code goes at the end after all the values for the prompts have been given. Of course this would mean doing a custom SQL on the report level

[b][i] AND
‘y’ in

(case when (LTRIM(@prompt(‘Enter Tex here:’,‘D/A/N’,‘Class\Object’,Mono/multi,Free/constrained,Not_Persistent,{’ '},User:1)) = ‘’)
then ‘y’

       else   (case when LTRIM(@prompt('Enter Text here:','D/A/N','Class\Object',Mono/Multi,Free/Constrained,Not_Persistent,{' '},User:2)) = 

Table.Column name
then ‘y’

                        else        'n'
                end)
end)[/i][/b]

This will do the trick


interactive :us: (BOB member since 2005-04-28)