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
It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn’t work. Instead, you need to: Open Advanced Mode in the Groupings pane. (Click the arrow to … Read more
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