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

36,595

Try something like this,

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

Share:
36,595
Pedram
Author by

Pedram

#SOreadytohelp C#.Net, VB.Net, ASP.NET, SQL SERVER, GitHub Actions, SonarQube, CICD

Updated on August 24, 2022

Comments

  • Pedram
    Pedram over 1 year

    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.