An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

(0) Share

Report

Posted on by safa weili

8308.expression.png

I am trying to use this expression {="Libellé :" +First(Fields!DEMLibelleprod.Value, "headercoupe")}, but I am getting this error when deploying the report.

Severity Code Description Project File Line Suppression State
Error Path: [AxReport/DEMPrintProdReport/Designs/DEMReport/Expression]:DEMReport: Unidentifiable substring 'First' in expression. The parser reported error message: Syntax error.

please help,thnaks in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (1)

Report

RE: An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

Hi safa weili,

You need to use "&" to append the string value. Try the bellow expression.

="Libellé :" & First(Fields!DEMLibelleprod.Value, "headercoupe")

Thanks,

Girish S.

Was this reply helpful? Yes No
safa weili 5 on at

Like (0)

Report

RE: An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

i used it but the problem persists

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

Can you show me the screenshot of the expression?

Also, where you are adding? I mean in the header or inside the tablix?

Thanks,

Girish S.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

Also, if you have used the same expression using "+" in other text boxes. Change that and also check.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

RE: An expression issue in SSRS report : : Unidentifiable substring 'First' in expression

Hi Safa Weili,

As Girish suggested you should use & not + for concatenation of strings in ssrs report.

Adding to Girish, can you remove those extra braces in that formula? It should look like below.

="Libelle:"&First(Fields!DEMLibelleprod.Value, "headercoupe")

Was this reply helpful? Yes No