Issues with Prompt in the Universe

building reports webintelligence
1

Hi Seniors,

Please help me out.

I have a serious concern with the prompt.
Whenever I am using the prompt with Mono it is getting parsed but if I am using Multi, I am getting the following error:

Parse failed:Exception:DBD ,[Microsoft SQL Server Native Cliebt 10.0] : Incorrect syntax near ‘,’.State :42000
:blue:
I have changed the “=” to “IN” in the where clause of the object but still is not getting any luck.

Please suggest how to fix this.

Thanks in advance!

Best Regards,
Sud

sud317 :canada: (BOB member since 2010-08-02)

2

Check in Universe that State has LOV’s check box Selected.
and replace comma with semi comma.
Please copy paste your syntax so at least have a better look.
Thanks

lionskashif :pakistan: (BOB member since 2011-01-21)