The SSRS Log10 function is a Mathematical function that returns the base 10 logarithmic value of the given numeric field (number). The syntax of the Log10 function to return the base 10 logarithmic value of a number is as shown below.
=Log10(15)
To demonstrate the Log10 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 Log10 function Example
To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Log10 function below finds and returns the base 10 logarithmic value of the orders column.
=Log10(Fields!Orders.Value)
Similarly, let me create two more columns to the right of the Cost and Sales and name them Log10 Cost and Log10 Sales. The SSRS Log10 function expressions below find the base 10 logarithmic values for the Standard Cost and Sales Amount columns.
=Log10(Fields!StandardCost.Value)
=Log10(Fields!SalesAmount.Value)
Please click the preview tab to see the Log10 report. Please use the FormatNumber or Round function to adjust the decimal precisions.
