SQL Server Performance

Custom Code errors

Discussion in 'SQL Server Reporting Services' started by dougwood, Feb 6, 2004.

  1. dougwood New Member

    Hey,
    I'm having problems getting my custom code to work in RS. There is minimal explanation in BOL, but I've tried to do something very simple to see if it works, with no luck.

    Here is the Custom code:



    Function ReturnVal(myNumber AS Integer) AS Integer
    Dim intNumer AS integer
    intNumber = myNumber + 4
    Return intNumber
    End Function


    In my report I have a field that is currently returning an integer value ( =Fields!total_hours.Value )

    now, as a test, I created another field and the exppression is


    =Code.ReturnVal(Fields!total_hours.Value)

    I am hoping the number will be 4 more than the original.
    This is the error I recieve when i try to preview:

    : [BC30451] Name 'intNumber' is not declared.

    Any suggestion about where else I need to declare this variable besides within my code block ?

    thanks a ton!

    Doug
  2. jasper_smith New Member

    You have a typo in your code [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br />"Dim intNumer AS integer" should be "Dim intNumber AS integer" <br />You can write this as <pre>Function ReturnVal(myNumber AS Integer) AS Integer<br />Return (myNumber + 4)<br />End Function</pre> <br /><br />HTH<br /><br />Jasper Smith
  3. dougwood New Member

    ooops,
    don't i feel stupid.
    thanks and sorry ![:I]

Share This Page