The SSRS Ceiling function is a Mathematical function that returns the smallest integer value greater than or equal to the given double-precision floating-point number. The syntax of the Ceiling function to return the nearest integer greater than or equal to the floating-point value in a numeric field is as shown below.
=Ceiling(5.67) - returns 6
=Ceiling(5.27) - returns 6
To demonstrate the Reporting Services Ceiling function, 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 Ceiling function Example
For this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Ceiling function below will return the nearest integer value of the SalesAmount column that is greater than or equal to the floating-point number.
=Ceiling(Fields!SalesAmount.Value)
Similarly, let me create one more new column to the right of the Cost and name it Ceil Cost. The SSRS Ceiling function expression below returns an integer value greater than or equal to the double-precision floating-point number in the standard cost column.
=Ceiling(Fields!StandardCost.Value)
Please click the preview tab to see the Ceiling report.
