How to select customers based on another field

[mtenboer]

I am running Crystal Reports 8.5

I want to select customers who have purchased an evaluation product, but have not gone on to buy any of 3 full versions of the product. I have grouped records by customer then by product, but I can not see how to write this selection criteria. Any help would be greately appreciated.

 

[dgillz]

This is a 4 step process:

1)Create a formula to test to see if they have purchased one of the Eval products:

If (ProductID} in [<<list all eval products here>>] then 1 else 0.

2) Create another formula to see if the bought the full product:

If (ProductID} in [<<list all full products here>>] then 1 else 0.

3) Perform simply summaries by customer on these 2 formulas.

4) The go to report, edit selection formula, group, and enter a selection formula:

Sum({@Evalformula},{CustID))> 0 and sum({@FullFormula},{CustID})=0

This will return only those customers that have purchased an eval product, but not a full product.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[mtenboer]

Thanks dgillz - it works perfectly!

/M