I have created a mock crosstab (CR2008) so that I would be able to display a value for every metric even if it was zero (current crosstab limitation). I have this displayed in the report footer and the values are calculated properly. My issue is though that I want the final totals to appear first and then show individual group results. So the first mock crosstab would be a grand total of the 10 crosstabs beneath it. I think this can only be done as a subreport but if anyone has any other idea's please let me know.