Home » Applications » Other Application Suites » prompt in BusinessObjects (BusinessObjects 12.1.0, Oracle 11)
prompt in BusinessObjects [message #509405] |
Fri, 27 May 2011 08:57 |
 |
ecivgamer
Messages: 147 Registered: May 2011 Location: Ukraine
|
Senior 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.
|
|
|
Goto Forum:
Current Time: Sat May 03 10:56:19 CDT 2025
|