Archives: August 2013
In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may have a series that you want aggregated differently than the series grouping.
For example, you may want to display a series… Read more
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the values for these parameters were passed from the parent report to the child. I wanted to add a third parameter to… Read more
I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30, 14 and 7 days. Displaying all the averages simultaneously would make the chart cluttered and confusing; instead, I opted to control the displayed average via a parameter that the user… Read more