Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Subreports with Totals V7.0.2.100 Info/Design

Status
Not open for further replies.

diana1

Technical User
Jan 9, 2001
3
US
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
 
One way would be to use one extra subreport, that pulls all the rebates at once, and then subtotals or cross-tabs them by Salesman.

You could try to bring them back using variables, and accumulate them with another variable for each salesman, but you would have to hard code a variable, formula and total for each possible salesman in the report. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top