I am trying to do the following in an SSRS report that has multiple subreports:
Parameters!MyMultiValueParameter.Count = CountRows("MyDataset"),
however I get #Error displayed instead of the list of items selected, this only occurs when the subreports are included in the report. It appears to be losing its focus.
If I pass parameter values to Report Custom Code it works however I am unable to pass CountRows(“myDataSet”) in order to do:
= Code.SetMyDept( JOIN(Parameters!p_dept_id.Label, ", "), Parameters!p_dept_id.Count, CountRows("dset_LkUp_Department") )
Public Shared Dim MyDept as String
Public Shared Dim DeptsSelected as Integer
Public Shared Dim TotalDepts as Integer
Public Function SetMyDept (ByVal var_dept as String, ByVal var_deptsSelected as Integer, ByVal var_totalDepts as Integer)
'MyDept = var_dept
'DeptsSelected = var_deptsSelected
'TotalDepts = var_totalDepts
MyDept = IIF( var_deptsSelected < var_totalDepts, var_dept, "ALL" )
Public Function GetMyDept() as String
'return IIF( DeptsSelected < TotalDepts, MyDept, "ALL" )
Any ideas please?