Add Code to a Report
Collapse the table of content
Expand the table of content

Add Code to a Report (SSRS)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In any expression, you can call your own custom code. You can provide code in the following two ways:

To add embedded code to a report

  1. In Design view, right-click the design surface outside the border of the report and click Report Properties.

  2. Click Code.

  3. In Custom code, type the code. Errors in the code produce warnings when the report runs. The following example creates a custom function named ChangeWord that replaces the word "Bike" with "Bicycle".

    Public Function ChangeWord(ByVal s As String) As String
       Dim strBuilder As New System.Text.StringBuilder(s)
       If s.Contains("Bike") Then
          strBuilder.Replace("Bike", "Bicycle")
          Return strBuilder.ToString()
          Else : Return s
       End If
    End Function
  4. The following example shows how to pass a dataset field named Category to this function in an expression:


    If you add this expression to a table cell that displays category values, whenever the word "Bike" is in the dataset field for that row, the table cell value displays the word "Bicycle" instead.

Community Additions

© 2016 Microsoft