Want to display only last 3 digits number in textbox in ssrs report

Question

I am getting output from sql is like 1011153, 1011154, 101155. I want to display only last 3 digits in like 153, 154, 155 respectively.

I'am using SSRS reports.

Answer 1

This should get you what you are looking for:

=Cint(Right(Cstr(Fields!ID.Value),3))

Answer 2

You can use this expression:

=IIF(Fields!your_field.Value.ToString().Length > 3, Fields!your_field.Value.ToString().Substring(Fields!your_field.Value.ToString().Length - 3, Fields!your_field.Value)

Answer 3

You could simply write:

=Right(Fields!YourID.Value, 3)