BusinessObjects 12.1.0 - prompt

[Former Member]

Hi all,

How do I use prompt for selecting field1 or field1+field2 depending on user's choice?

I think about :

select case when @prompt1 = 1 then field1 else field1+field2 end from table1

Choice field1+ field2 should be by default. Choises 1,2 should be named user-friendly like "choice A", "choice B".

But I do not know the syntax at all. Give me please some example or tell me where to read about it.

Thanks ahead.

[Former Member]

hi,

Please create an object in Universe with the following definition.

Object1

@Prompt('Select Your Choice:','A',{'Choice A','Choice B'},mono,free,persistent,{'Choice B'})

Include the above object in your query. Run the report.

Create a Variable 'Var1' with the following definition.

=if UserResponse('Select Your Choice:') ="Choice A" then [field1] else [field1]+[field2]

Regards,

Vamsee