stevenofva
asked on
Custom code in SSRS
I am setting up code in the custom code area of report properties in SSRS 2008. I am having problems setting up the public function for two fields. I have to have one for pbm_propertyClass and one for pbm_TotalAssessment. I need the pbm_propertyClass to set up and If statement to see if it less than 710 and if so add the total to nonexempt field to use in a percentage calculation. Then if it less than 710 I willl need to set up a seperate function I believe. My problem is I don't know how to declare both virables in one public function statement. Both of these virables are table fields in the dataset. it gives me the following error when I try to view the report. The definition of the report 'PropertyClass is invalid. There is an error on line 1 of custom code:[BC30205] End of statement expected.
' Non Eempt Property values
Public function PropClass(ByVal pbm_PropertyClass as Integer), nonexempt (byval pmb_totalAssessment as integer)
' Non Exempt property classes are less than 710
If pbm_PropertyClass < 710
NonExempt = NonExempt + pbm_TotalAssessment
End if
End Function
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_7316-Variable-Custom-Code-and-Assembly-reference-in-SSRS.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for not thinking everybody yesterday I got busy with another project. Thank you for helping me with the code.
Steve
Steve
Glad to help :)