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

reporting-services ssrs-expression
pedram picture pedram · Dec 7, 2015 · Viewed 34.6k times · Source

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.

Answer

Ankit Sondagar picture Ankit Sondagar · Dec 7, 2015

Try something like this,

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

Related questions

SSRS Field Expression to change the background color of the Cell

I'm trying to write a field expression for a Cell in my report where I have to change the background color of the cell depending on the string value in the cell. Ex: if the column has a value 'Approved' …

Read More
Reporting Services Remove Time from DateTime in Expression

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Read More
SSRS Expression for IF, THEN ELSE

I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression. =if(Fields!ExitReason.Value 7, then if (Fields!ExitReason.Value 1, else if (Fields!ExitReason.…

Read More