Just want to run a best practice question by some of you. I've been toying around with designing a report, it would be a report on total calls and response times per month (by year) as well as the average number of calls and average rep time per year. This is where I had some problems
So initially I went for the option to do it by a table, with some totals added and then tried to go with a Matrix.
The Matrix would appear to be the better option but it proves to be quite inflexible when it comes to creating values from a dataset i.e. avg(calls) or total avg(calls).
Using either option I found that I still had to go down the road of prepping the data in the queries instead of the values being generated at report run time.
Would anyone have any sample reports of working out averages, complex grouping etc? Is it best practice with SSRS 2008 to do most of the calculations / aggregation in the dataset query itself?