Wednesday, 10 May 2017

SSRS - Remove decimals If result is whole number


Remove decimals If value is whole number.

Example: If value is 28.00 then report should show 28 and If value is 28.25 then report should show 28.25

How we can achieve this.

Add expression in this report and add below lines.


=Replace(Round(Fields!HourPerWeek.Value,2),".00","")

or

=CDec(Replace(Fields!HoursPerWeek.Value,".00",""))

No comments:

Post a Comment

Azure MCP - Building AI-Powered Tools with Model Context Protocol

  Introduction to Model Context Protocol (MCP) Artificial Intelligence is rapidly transforming how we build software. As LLMs (Large Languag...