crystalpro
Technical User
I created a report to list each sales reps sales showing the customer id, customer name, contact, phone, sales amount and commission (commission is calculated).
I also need the report to show the customers that did not have any sales in the report date range chosen.
The report I created uses the jrnlrow table to list the sales. If a customer is not in the jrnlrow table for the selected date range, then it is assumed this customer purchased 0.00.
How can I create a formula to show these customers (those that purchased 0.00 amount) on the report, too?
I also need the report to show the customers that did not have any sales in the report date range chosen.
The report I created uses the jrnlrow table to list the sales. If a customer is not in the jrnlrow table for the selected date range, then it is assumed this customer purchased 0.00.
How can I create a formula to show these customers (those that purchased 0.00 amount) on the report, too?