[BC30451] Name 'code' is not declared.

• amirhh2000

  SSChasing Mays

  Points: 660

  More actions

  November 8, 2011 at 5:53 pm

  #259653

  Hi all,

  I am using "code.matrixcellvalue" in my matrix in a report. this is the script:

  =code.matrixcellvalue(

  Count(Fields!emp_id.Value)

  ,avg(Fields!Age.Value)

  ,InScope("matrix1_emp_category") and InScope("matrix1_Age")

  ,"{0,6:N0}"

  ,"{0,6:N0}")

  The problem is when I try to preview the report it comes up with this erro:

  [rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox3’ contains an error: [BC30451] Name 'code' is not declared.

  What is strange is that I am using the exact code in another report and that report has no problem. The only difference is that the other report is in another solution.

  Any suggestion?

• amirhh2000

  SSChasing Mays

  Points: 660

  More actions

  November 8, 2011 at 6:08 pm

  #1404928

  Well I found my answer

  As "code.matrixcellvalue" is a custom It needs to add the following script to the

  Report Property -> code

  Public Function MatrixCellValue(ByVal sumValue As Object, ByVal avgValue As Object, ByVal InScope As Boolean, ByVal sumFormat As String, ByVal avgFormat As String) As Object

  If InScope Then

  Return sumValue

  Else

  If Not avgValue Is Nothing Then

  Return String.Format(sumFormat, CDbl(sumValue)) + vbCrLf + String.Format(avgFormat, CDbl(avgValue))

  Else

  Return Nothing

  End If

  End If

  End Function