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 Function - In-process model vs Isolated worker model

 In-process model Your function code runs inside the same process as the Azure Functions runtime Uses the WebJobs SDK . [FunctionName(...