BusinessObjects 12.1.0 - prompt
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.