Geek Answers Handbook

ID of expected error when trying to deploy an SSRS project using custom code

I have a project with this custom code:

Public Function GetStdDev(ByVal Sum1 as Integer, ByVal Sum2 as Integer, ByVal Sum3 as Integer, ByVal Sum4 as Integer, ByVal Sum5 as Integer, ByVal WAvg as double) as Double Dim aleph = 5/60 Dim w1 = (Sum1 - WAvg)^2 Dim w2 = 2 * ((Sum2 - WAvg)^2) Dim w3 = 3 * ((Sum3 - WAvg)^2) Dim w4 = 4 * ((Sum4 - WAvg)^2) Dim w5 = 5 * ((Sum5 - WAvg)^2) Dim alpha = (w1 + w2 + w3 + w4 + w5) / 5 Dim beta = sqrt(alpha * aleph) Return beta End Function

The report can be viewed just fine, but when I deploy it, I get this error:

 There is an error on line 0 of custom code: [BC30203] Identifier expected.

I have no idea what the SSRS problem is. Can anyone enlighten me?

Thanks!

+6
source share
2 answers

This is a classic case of programming rule number 1: "I'm dumb." The problem is that I did not put underscores in the function declaration, as I forgot that you had to do this in VB. Why the preview did not complain, I will never know. Corrected Code:

 Public Shared Function GetStdDev(ByVal Sum1 as Integer, ByVal Sum2 as Integer, _ ByVal Sum3 as Integer, ByVal Sum4 as Integer, _ ByVal Sum5 as Integer, ByVal WAvg as double) as Double Dim aleph as double = 5/60 Dim w1 as double = (Sum1 - WAvg)^2 Dim w2 as double = 2 * ((Sum2 - WAvg)^2) Dim w3 as double = 3 * ((Sum3 - WAvg)^2) Dim w4 as double = 4 * ((Sum4 - WAvg)^2) Dim w5 as double = 5 * ((Sum5 - WAvg)^2) Dim alpha as double = (w1 + w2 + w3 + w4 + w5) / 5 Dim beta as double = sqrt(alpha * aleph) Return beta End Function
+10
source

You need to note the following functions:

 Public Shared Function GetStdDev`(ByVal Sum1 as Integer, ByVal Sum2 as Integer, ByVal Sum3 as Integer, ByVal Sum4 as Integer, ByVal Sum5 as Integer, ByVal WAvg as double) as Double
0
source

More articles:


All Articles