Simplified form of problem -
Customers in Cdata, Sales data in SData. SData includes Salesman as a field that can be null. (Often filled, but not required.)
A customer can have multiple sales - Report has customer ID as a group, and their is a time value to limit which sales are reported.
Need function FSalesman:
If no sales data in timeperiod or no sales with salesman entered;
If only one salesman in data, then FSalesman = Saleman Name (May be in multiple times; )
If two or more salesman had sales in the time period selected, FSalesman = "Multiple"
Crystal reports XI
November 10, 2009 7:33 PM
November 10, 2009 7:49 PM