ssrs-tablix

Need help in calculation using two Datasets using Expression SSRS

by

You would need to restrict your dataset to the desired month and then sum the results. LookupSet is used to retrieve data from another dataset based on criteria. A VBA function, SumLookup is needed to add the results from the LookUp. This VB would go into the CODE section of the report (this can be … Read more

SSRS Expression Divide by Zero Error

by

You can add a function to your report code that handles the divide by zero condition, this makes it a bit easier to implement in multiple cells, e.g. Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double) If IsNothing(Divisor) Or Divisor = 0 Return 0 Else Return Dividend/Divisor End If End Function You … Read more