Add a function

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  December 4, 2013 at 10:52 am

  #283232

  Where can I add this function in report builder? unable to figure out.

  Function GetColor(ByVal CategoryGroupMember As String) As String

  Dim ColorCode As String

  Select Case CategoryGroupMember

  Case "Australia"

  ColorCode = "#AC9494"

  Case "Canada"

  ColorCode = "#37392C"

  Case "France"

  ColorCode = "#939C41"

  Case "Germany"

  ColorCode = "#6B8272"

  Case "United Kingdom"

  ColorCode = "#D29B48"

  Case "United States"

  ColorCode = "#3C4848"

  End Select

  Return ColorCode

  End Function

  Thanks.

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  December 4, 2013 at 12:35 pm

  #1670829

  Figured out...

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