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.



Previous Topic: CrossReference with MTL_Cross_References
Next Topic: SAP xMII with string more than 4000 char
Goto Forum:
  


Current Time: Thu Mar 28 17:20:40 CDT 2024