SSRS Int Function

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.

Source Table

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.

  1. More Functions
  2. Charts
  3. Tables
  4. Format tables
  5. SSRS
=Int(Fields!SalesAmount.Value)
SSRS Int Function expression to return the integer portion

Similarly, let me create two more new columns to the right of the Cost and Grade columns. The SSRS 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.

SSRS Int Function to return the integer portion report preview