Link to home
Start Free TrialLog in
Avatar of stevenofva
stevenofvaFlag for United States of America

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

Open in new window

Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stevenofva

ASKER

Sorry for not thinking everybody yesterday I got busy with another project. Thank you for helping me with the code.
Steve
Glad to help :)