SSRS BigMul Function

The SSRS BigMul function is a Mathematical function that helps to perform the multiplication of a big number by returning the full product of two 32-bit numbers. The syntax of the BigMul function to return the full product of two 32-bit numbers is as shown below.

=BigMul(2147483647,-2147483647)

To demonstrate the SSRS BigMul 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.

Source Table

SSRS BigMul function Example

To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. Since this report does not contain big numbers, we use the existing ones. The BigMul function below will multiply the Standard Cost values with the Sales Amount.

  1. More Functions
  2. Charts
  3. Tables
  4. Format tables
  5. SSRS
=BigMul(Fields!StandardCost.Value, Fields!SalesAmount.Value)
SSRS BigMul Function expression

Please click the preview tab to see the BigMul report.

SSRS BigMul Function to multiply big numbers report preview