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.



Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 31 08:24:29 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.