SSRS : How to call sub report grand total on main report

How to call sub report grand total on main report?

Do you have main report with one or more sub report and need to bring the grand total of each sub report to main report within a group? Here is the trick to do this.

You can maintain the sub report as it is. However you need to define same datasets on the main report passing same parameters that you pass to sub reports. The create another tablix with grand total columns on the main report and call these datasets for grand total.

When you view the report, sub report will bring the data and show the sub total within the search group but grand totals for sub reports will be called from the dataset on the main report separately (not from sub report).

Remember to pass the same parameters that you pass to sub reports.