TBSupport
asked on
SSRS: Totaling on the Subreport and Main Report
Hello:
Attached is my SQL Reporting Services (SSRS) main report and one of its subreports. On this subreport, I would like to have it total by vendor (the POP10100.VENDORID field).
Also, I would like for the main report to pull a "grand total" of the Past Due field for each vendor, from the subreport onto the main report.
How do I accomplish these two tasks?
In addition, I have attached a Word document showing the results of generating the report. The first screenshot is the top half of the report, while the second screenshot is the lower half.
Thanks!
TBSupport
POOR-Past-Due-Subreport.rdl
No-Totals.docx
POOR.rdl
Attached is my SQL Reporting Services (SSRS) main report and one of its subreports. On this subreport, I would like to have it total by vendor (the POP10100.VENDORID field).
Also, I would like for the main report to pull a "grand total" of the Past Due field for each vendor, from the subreport onto the main report.
How do I accomplish these two tasks?
In addition, I have attached a Word document showing the results of generating the report. The first screenshot is the top half of the report, while the second screenshot is the lower half.
Thanks!
TBSupport
POOR-Past-Due-Subreport.rdl
No-Totals.docx
POOR.rdl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.