Background:
I have read the FAQs on linking a subreport to the main report so that parameters need only be entered once, and am trying to do this now.
The function of each subreport is to total rebates, by salesperson, for different vendors, customers, contracts, and products.
I have 9 reports (that should be subreports) for 9 different vendors already created, and they all require a Month and Year parameter selection from user. I have tried to combine all the reports' data selection into one report, but there become too many if/then statements and selection criteria for it to work. The reports look something like this:
Vendor A
Salesperson 1 - $3
Salesperson 2 - $8
Vendor B
Salesperson 1 - $2
Salesperson 2 - $4
Salesperson 3 - $5
Question:
Is there any way to total the rebate amount(s) by salesperson at the reports' end? What I would like to see is just the totals of the subreports, as follows:
All Vendors:
Salesperson 1 - $5
Salesperson 2 - $12
Salesperson 3 - $5
Thank you in advance for your kind and expert help!
-Diana
I have read the FAQs on linking a subreport to the main report so that parameters need only be entered once, and am trying to do this now.
The function of each subreport is to total rebates, by salesperson, for different vendors, customers, contracts, and products.
I have 9 reports (that should be subreports) for 9 different vendors already created, and they all require a Month and Year parameter selection from user. I have tried to combine all the reports' data selection into one report, but there become too many if/then statements and selection criteria for it to work. The reports look something like this:
Vendor A
Salesperson 1 - $3
Salesperson 2 - $8
Vendor B
Salesperson 1 - $2
Salesperson 2 - $4
Salesperson 3 - $5
Question:
Is there any way to total the rebate amount(s) by salesperson at the reports' end? What I would like to see is just the totals of the subreports, as follows:
All Vendors:
Salesperson 1 - $5
Salesperson 2 - $12
Salesperson 3 - $5
Thank you in advance for your kind and expert help!
-Diana