<div>
I solved this, by removing the parameters for this second subreport. &nbsp;Odd.
</div>


I solved this, by removing the parameters for this second subreport.  Odd.

<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
In SQL Reporting Services (SSRS), I created a subreport that displays the Grand Total of dollar figures on the main report.<br />
<br />
When I copy and paste that subreport onto the main report and link it by parameters for both reports, the Grand Total does not display accurately on the main report.<br />
<br />
I have another subreport that is configured very similarly. &nbsp;On the main report, that subreport correctly displays its data.<br />
<br />
What are some things that I should review, in order to have the Grand Total display accurately?<br />
<br />
Thank you!<br />
<br />
John
</div>
</div>


Hello:

In SQL Reporting Services (SSRS), I created a subreport that displays the Grand Total of dollar figures on the main report.

When I copy and paste that subreport onto the main report and link it by parameters for both reports, the Grand Total does not display accurately on the main report.

I have another subreport that is configured very similarly.  On the main report, that subreport correctly displays its data.

What are some things that I should review, in order to have the Grand Total display accurately?

Thank you!

John

SSRS: Displaying the Grand Total from a Subreport

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.