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.