Search code examples
reporting-servicesssrs-2008ssrs-2008-r2ssrs-tablixssrs-2012

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


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.


Solution

  • This should get you what you are looking for:

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