I am using Crystal Reports XI R2. I have a report that pulls all the customer from our Customer Master database creates sheets of address labels. This report only created one label per customer.
I was asked by Customer Support to add a parameter to only print customer labels with customer orders between a date range they choose. I added the parameter and had to add another table for the order dates. I linked the tables by the Customer ID. I added a Record Selection formula (previously there was none) and ran the report.
I now get one label for every order instead of one label for every customer. I get multiple labels for each customer; one for each order, I believe. I changed the table link from
Not Enforced and got it to drop about 350 records with both
Enforced To and
Enforced From. How can I correct this so that I get only one label for each customer who placed an order between the specified dates?
Tables in report:
Customer Master
Order Master
Tables linked:
Customer Master.CustID ---LOJ---> OrderMaster.CustID
Record Selection formula:
{Order Master.ORDERDATE} in {?Date Range}
I have all the fields for the label in a text box and I have formatted it to
Suppress If Duplicated, but it does not have any effect since technically the records aren't duplicates.