I am a very new user of Crystal. I want to show sales in the year 1996 for all customers in California. So I wrote the following selection formula:
{Customer.Region}="CA" and {Orders.Order Date} in Date (1996, 02,18) to Date(1996,12,31)
When I ran the report, I lost customers from California that didn't have any orders in that time period. I don't want that. I want all California customers to appear regardless of whether they had sales. Also, I want those customers without sales to display the text "No Sales."
The report includes a formula that groups the report by Customer Name with Customer ID in parentheses. The report also includes the Orders.Order Amount field with a summary and grand total thats sums the Order Amount field.
How can I edit my selection formula above to include the nulls and when the nulls are displayed, display the text No Sales?
Thanks for any light you can shed.
{Customer.Region}="CA" and {Orders.Order Date} in Date (1996, 02,18) to Date(1996,12,31)
When I ran the report, I lost customers from California that didn't have any orders in that time period. I don't want that. I want all California customers to appear regardless of whether they had sales. Also, I want those customers without sales to display the text "No Sales."
The report includes a formula that groups the report by Customer Name with Customer ID in parentheses. The report also includes the Orders.Order Amount field with a summary and grand total thats sums the Order Amount field.
How can I edit my selection formula above to include the nulls and when the nulls are displayed, display the text No Sales?
Thanks for any light you can shed.