An example of my situation:

I have a list of dogs. They can be black, grey, white, or brown and some have multiple colors in their fur :-)

When I run a report, I want to be able show all dogs that have the colors I choose. So, lets say I want to see brown, black and white. The report needs to show all dogs with those colors anywhere on them. Even if they have two colors.

When the data for color is input, it is input as Y or N, for some reason this was how our database was designed. So example, when a new dog is input, someone goes down the line and checks Y or N for each color on the dog.

My first instinct is to have a formula that says:

color(brown) = parameter(brown) OR color(black) = parameter(black) OR color(white) = parameter(white)

But this formula stops working past two parameters.

What is the correct way to set up a formula like this where each record may have more than one "description"?

I've been working on this forever and I'm just not good enough! BTW, the dog situation is an example not the real problem. I'm dealing with subcontractors that have multiple business classes.

Thanks!

I think the OR is the correct approach as you want all results that meet any color condition entered.

It can be done but you have to deal with NULLs.

I am going to guess these are all boolean fields and your paramters are also boolean.

Edited by DBlank - 26 Sep 2011 at 10:17am

FYI - if you have NULLs in your DB and you do not tell crystal what to do with the NULLs (various locations to do this) it can stop evaluating the formula when it hits a NULL. When you changed the formula to 'use default values for Nulls' it allows the formula to interpret the Nulls as False for the booleans and therefore continue to evaluate the whole row for all conditions and return the correct rows.