The SSRS Sqrt function is a Mathematical function that returns the Square root of the specified number or numeric field. The syntax of the Sqrt function to return the Square root of a numeric field is as shown below.
=Sqrt(25)
=Sqrt(Fields!SquareRoot.Value)
To demonstrate the Sqrt 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 Sqrt function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Sqrt function below will find and return the Square root of the Angle field or column.
=Sqrt(Fields!Angle.Value)
Similarly, let me create one more new column to the right of the Sales and name it Sqrt Sale. The SSRS Sqrt function expression below finds the Square root of the Sales Amount column.
=Sqrt(Fields!SalesAmount.Value)
Please click the preview tab to see the Sqrt report. Please use the FormatNumber function to adjust the decimal precisions.
