SSRS Exp Function

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.


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.

Source Table

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.

  1. More Functions
  2. Charts
  3. Tables
  4. Format tables
  5. SSRS
SSRS Exp Function expression to find the exponential value

Please click the preview tab to see the Exp report.

SSRS Exp Function to find the exponential value e raised to the power report