Hi All,
I am using terdata as a backened, using cognos 8.3
I am facing an issue while creating a filter in report studio.
My expression is as follows: [Sale GLA].[Global Modality].[A Level Modality Desc] in ('DI X-Ray','Cardiology')
The issue is If I am having a single data value in ('DI X-Ray'), It works but if brackets contain more then 1 value, it fails.
The error I am facing is as follows:
QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position: 68 of:"[Sale_GLA].[Global Modality].[A Level Modality Desc] in ('DI X-Ray''
QE-DEF-0261 QFWP-parsing text:[Sale GLA].[Global Modality].[A Level Modality Desc] in ('DI X-Ray','Cardiology')
Your guidance is appreciated
Thanks in advance
I have seen problems like this before. Try changing your separator from a comma to a semi-colon:
. . . in ('DI X-Ray';'Cardiology')
Hi Micheal,
Thanks much for your reply.
It worked.
Highly appreciated.
Thanks again
Regards
saumil