Susmitha Sajja
asked on
Crystal Reports
I am trying to create a crystal report. I have customers, work orders and the date enter for that work order. I am trying to show the new customers in past 3 years. I can't just exclude date enter below 2015 and show customers above the year 2015. if a customer been using us from 1990 and still using us will also appear if I exclude date enter below 2015. since some work orders are there for that customer after 2015. I want to see the minimum date enter and exclude those customers whose minimum date is less than 2015.
Problem with that is I can do filters on summarized values like sum, max, min in the crystal.
Is there any other approach for this?
Problem with that is I can do filters on summarized values like sum, max, min in the crystal.
Is there any other approach for this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It would give me wrong information. For example if a customer used us in 1994 and used us again in 2017. It would show him since he used in 2017. I don't want him to be shown. I want minimum date enter is above 2014. And can you help me in crystal logic
No it won't. The select in the where clause finds all customers with work orders before the cutoff date. The SQL for the report then selects only customers NOT in that list
mlmcc
mlmcc
Group by the customer id
Click REPORT --> SELECTION FORMULAS --> GROUP
Enter something like
Minimum({WODATEfield},{Cus
This only suppresses the customers who had work before the date.
If you do any summaries the suppressed customer data will be included
mlmcc