CODEWITHSUNDEEP
reporting-servicesssrs-expression
Pedram
Pedram

Reputation: 6508

convert integer value to string and if it fails set "##" - SSRS

I have below line in crystal report formula, It means that if string conversion failed it will print ##.

CStr({rptReport;1.Total},"##")

Now, the question is how can I achieve this by SSRS Expression.

Upvotes: 7

Views: 45802

Answers (1)

Ankit Sondagar
Ankit Sondagar

Reputation: 186

Try something like this,

=IIF(CStr(Fields!Total.Value),CStr(Fields!Total.Value),"##")

Upvotes: 17

Related Questions