The SSRS Int function is a Mathematical function that returns the integer portion of the given numeric field or the double-precision floating-point number. The syntax of the Int function to convert or return the integer portion is as shown below.
=Int(-10.4)
=Int(10.546)
To demonstrate the Int function in Reporting Services, we use the Products table below, which has 14 records. The image shows the records in the table report; the result is in an empty column.
SSRS Int function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Int function below will return the integer portion of the floating-point number in the SalesAmount column.
=Int(Fields!SalesAmount.Value)
Similarly, let me create two more new columns to the right of the Cost and Grade columns. The Int function expression below returns the integer portion of the Standard Cost and Service Grade column values and their sign.
=Int(Fields!StandardCost.Value)
=Int(Fields!Service_Grade.Value)
Please click the preview tab to see the Int report.
