ChuckDeezel
asked on
Help With Crystal Reports Selection Formula
I am in need of some suggestions on how to create a selection formula in Crystal Reports. I have never used a formula to filter data (Selection). I have always used the Select Expert. Here goes.
I need a formula that will return data based on 2 possible conditions.
We have a field that I will call Owner Company and another called Owner Group. I need this formula to return all data that is external to our company, but I also need to return data that IS internal to our company, but ONLY from a specific Owner Group.
So the formula would read in plain english:
IF OWNER COMPANY IS NOT EQUAL TO INTERNAL OR IF OWNER GROUP IS EQUAL TO INTERNALSUBGROUP THEN RETURN RECORDS
Hopefully this makes sense to anyone reading. If not let me know.
I need a formula that will return data based on 2 possible conditions.
We have a field that I will call Owner Company and another called Owner Group. I need this formula to return all data that is external to our company, but I also need to return data that IS internal to our company, but ONLY from a specific Owner Group.
So the formula would read in plain english:
IF OWNER COMPANY IS NOT EQUAL TO INTERNAL OR IF OWNER GROUP IS EQUAL TO INTERNALSUBGROUP THEN RETURN RECORDS
Hopefully this makes sense to anyone reading. If not let me know.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No, just use that formula in the selection formula
mlmcc
mlmcc
ASKER
I see. I have to check the data to confirm success.
Ill reply shortly.
Ill reply shortly.
ASKER
Selection formula worked. Thanks. I was partially on the same track as your solution. Thing is that I wasn't sure how best to implement since I had never used a formula to select. Now I know. You learn something everyday. As always thanks for the prompt reply MLMCC.
ASKER
THEN 1
ELSE 0
Then I can plop into the selection expert CustomFormula = 1?
Trying this now.