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),"##")
Author by
Pedram
#SOreadytohelp C#.Net, VB.Net, ASP.NET, SQL SERVER, GitHub Actions, SonarQube, CICD
Updated on August 24, 2022Comments
-
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
.