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.