The SSRS Fix function is a Mathematical function that returns the integer portion of the specified double-precision floating-point number or numeric field. The syntax of the Fix function to return the integer portion is as shown below.
=Fix(-15.4)
=Fix(10.56)
To demonstrate the Fix 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 Fix function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Fix function below will return the integer portion of the floating-point number in the SalesAmount column.
=Fix(Fields!SalesAmount.Value)
Similarly, let me create two more new columns to the right of the Standard Cost and Service Grade columns. The SSRS Fix function expression below returns the integer portion of the Standard Cost field and Service Grade column values.
=Fix(Fields!StandardCost.Value)
=Fix(Fields!Service_Grade.Value)
Please click the preview tab to see the Fix report.
