Filter issue in Report Studio

[saumil287]

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

[Michael75]

I have seen problems like this before. Try changing your separator from a comma to a semi-colon:

Code Select Expand

. . . in ('DI X-Ray';'Cardiology')

[saumil287]

Hi Micheal,

Thanks much for your reply.

It worked.

Highly appreciated.

Thanks again

Regards
saumil