"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Thanks for the replies. I don't believe I stated the question correctly. If I needed a formula to only display records that had two attributes in common how can I accomplish this? For example I want to display records for customers who are in our VIP club and who have purchased X product. I apologize for the confusion. Also I am very new to Crystal so if you can provide a step by step answer explaining where and how to insert the formula into the report that would be great. Thanks so much.

mlmcc's suggestion sounds good, but we don't really know anything about your data. For one thing, you mentioned customers and products -- Are the customer and product fields that you're checking both in the same table, or separate tables? If they're in separate tables, how are they linked?

If mlmcc's suggestion didn't give you any records, what happens if you try each part separately?

Try {field1} = "VIP" and see what you get, then try {field2} = "productX" and see what you get. Obviously, replace the field names and values with your field names, and the values you're actually looking for.

You are entering those tests in the record selection formula, correct? For example, Report > Selection Formulas > Record.

James

wayy2beAuthor Commented: 2014-11-10

The fields are in the same table. I may not be explaining correctly. What I need is that if a field has VIP and another field has Product X then display those records that meet that criteria. For example VIP and Product B, no data is displayed.

If the two values that you're looking for are in the same record, then it really should be just as simple as the formulas that mlmcc and you posted earlier. You should be able to just go to Report > Selection Formulas > Record and enter a formula like this:

{field1} = "some value" and {field2} = "some other value"

If the fields could be null, you may need to test for that, but apart from that, it should be just that simple. Which is why we keep asking these other questions (how many tables, are the values in the same record, and so on). What you described seems pretty basic, so if it's not working, we're missing something.

James

wayy2beAuthor Commented: 2014-12-05

Sorry for the delay. I will test it again and report back on Monday. Thanks