Thanks to Robert and Paul for their amazing book - SQL Server Reporting Services Recipes. I'm fairly new to SSRS and this is a great resource.
I have one problem with the getmedian() code currently. I adapted the code to utilize this code for multi-category box plots. Everything turns out great in viewing, but all of the expression-based points of the chart dissapear and I can't
figure out why. Its like the arraylist is not populating. Even print layout shows everything blank, except for the average line, which is not reliant upon the code.
Below is the code.
Dim DrugLag as New system.collections.arraylist
Dim RadiationLag as New system.collections.arraylist
Function AddChargeLagValue (newChargeLagValue as Decimal, filterDepartment as String) as Decimal
IF (filterDepartment = "Drugs")
ELSEIF (filterDepartment = "Radiation")
AddChargeLagValue = newChargeLagValue
Function GetMedian(filterDepartment as String) as Decimal
Dim MedianLag as New system.collections.arraylist
View Complete Post