Accessing parameters in custom code RRS feed

  • Question

  • Hi,


    I am trying to retrieve and manipulate the value of the stored procedure parameters in the following custom code:



    Code Snippet

    Public Function ShowLoading(ByVal intOption as integer, byVal BasicLoading as string, byVal BasicHealthExtra as string, byVal RiderLoading as string, byVal RiderHealthExtra as string, byVal TotalAmount as string) As string

      dim strRider as String
      dim strCompanyName as string

      strCompanyName = Fields!CompanyName.Value


      select case  strCompanyName
         case "and Plus Rider ":
            strRider = "Plus Rider"
         case "and Assist Rider ":
            strRider = "Assist Rider"
      end select

      return strRider

    End Function 



    However, i got this error when I try to preview the report: An error occurred during local report processing, The definition of the report :


     '/reportC' is invalid. There is an error on line 5 of custom code: [BC30469] Reference to a non-shared member requires an object reference.


    Any help is greatly appreciated. Thanks in advance.


    Thursday, February 21, 2008 7:53 AM