• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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.
0
ChuckDeezel
Asked:
ChuckDeezel
  • 3
  • 2
1 Solution
 
mlmccCommented:
{OwnerCompanyField} <> "YourCompany"
OR
{OwnerGroupField} = "YourSubGroup"

mlmcc
0
 
ChuckDeezelAuthor Commented:
And then maybe have it do a
THEN 1
ELSE 0

Then I can plop into the selection expert CustomFormula = 1?

Trying this now.
0
 
mlmccCommented:
No, just use that formula in the selection formula

mlmcc
0
 
ChuckDeezelAuthor Commented:
I see. I have to check the data to confirm success.

Ill reply shortly.
0
 
ChuckDeezelAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now