on 08-19-2014 4:42 PM
Hello All,
I'm facing an issue with prompt error, error message is Microsoft SQL server native client 10.0: An expression of non boolean type specified in a contextwhere a condition is expected near ')'
object formula: @prompt('enter message','A','Department\group name',mono,free,persistent)
BO version: Business Objects 4.0 Sp2
Database: Microsoft sql server 2008
Regards,
Shekar
Are you having a condition in the prompt syntax ? Prompts needs to be defined with a condition for example.. TABLENAME.CUSTOMER_NAME IN @Prompt('Enter Customer NAME','A',,Multi,Free,Persistent,{'ALL'})
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Curious if you ever found an answer to this problem.
I am having the same issue when I try to use an MONO @prompt, I need to use "in" operator to get past one error but then it doesn't parse in the webi report. If I use an "=" it parses in webi but gives error in universe.
Guessing this is related to the SQL Server Native Client 10.0. I use this so I can make OLE DB connections to the database.
Curious if you found a way around it. Works find when you use in/multi but can't seem to use mono.
Tammy
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.