Cognos 8 - Report Studio QE-DEF-0459 CCL Exception while adding Data Item Expression

Vote count:

0

I added below code in Data Item Expression in Report Studio

CASE WHEN patindex('%- %', [Global_Resources].[Data Collection Feature V2 Class].[Session]) = 0 THEN [Global_Resources].[Data Collection Feature V2 Class].[Session] ELSE LEFT ([Global_Resources].[Data Collection Feature V2 Class].[Session],patindex('%- %', col_160) - 1) END

while validating the expression I am getting below error in Cognos 10 - Report Studio

Could you please suggest

QE-DEF-0459 CCL Exception

QE-DEF-260 Parsing error before or near postion: 179 of :"CASE WHEN patindex('%- %', [Global_Resources].[Data Collection Feature V2 Class].[Session]) = 0

THEN [Global_Resources].[Data Collection Feature V2 Class].[Session] as 'A'

ELSE

LEFT ([Global_Resources].[Data Collection Feature V2 Class].[Session],patindex('%- %', col_160)

QE-DEF-261 QFWP - Parsing text: CASE WHEN patindex('%- %', [Global_Resources].[Data Collection Feature V2 Class].[Session]) = 0

THEN [Global_Resources].[Data Collection Feature V2 Class].[Session] as 'A'

ELSE

LEFT ([Global_Resources].[Data Collection Feature V2 Class].[Session],patindex('%- %', col_160) - 1) as 'A'

asked 1 min ago

Richi Varma

1

Cognos 8 - Report Studio QE-DEF-0459 CCL Exception while adding Data Item Expression