How To do Grand Total from my Sub reports.

[MoeSSRS]

I added 5 subreports to do the individual subtotals on my main report in SQL Server Reporting Services 2005. What is the easiest way to calculate a Grand Total from my individula subreport subtotals. Thanks and appreciate your quick response.

 

[RiverGuy]

Are the five subreports referencing the same report, but with different criteria? What I normally do is reuse the same subreport, but pass in parameters so that it will bring back the grand total. For example, if your subreports are for clients, and you're passing in a ClientID parameter, you could pass in a 0, which your subreport's dataset's query would use to return summary data for all clients.

 

[MoeSSRS]

Yes all my reports referencing to Hitkey Id but no different criterias. I am getting subtotals on each subreport which is fine but I need a grand total of those 5 subreports subtotals. Let me try and see it works. Thanks and appreciated.