Crystal XI - MAS90 - SalesPersonCode

[CrystalLion]

I am having a heck of a time getting the SalesPersonCode (SalesPersonNumber) to print on an Invoice Report.

For testing purposes, I linked

ARD_SalespersonMasterfile (equal join to)
AR1_CustomerMaster

The report runs fine, showing me SalesPerson and their associated Customers.

When I add the Invoice file (thus ending up with)

ARD_SalespersonMasterfile (equal join to)
AR1_CustomerMaster (equal join to)
ARN_InvHistoryHeader

the report gags. Stops dead in its tracks, and I haven't even added the InvHistoryDetail file.

Any ideas?
Thanks

 

[dgillz]

What field(s) did you use to join these 2 tables?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry