The SSRS Exp function is a Mathematical function that returns the exponential value raised to the given power value (numeric field). The syntax of the Exp function to return the exponential value of a numeric field is as shown below.
=Exp(3)
We use the Products table below to demonstrate the Exp function in SQL Reporting Services, which has 14 records. The image shows the records in the table report; the result is in an empty column.
SSRS Exp function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Exp function below will find and return the exponential value that is e raised to the power of the Orders column.
=Exp(Fields!Orders.Value)
Please click the preview tab to see the Exp report.
