Help!

[Dehalo212]

I am a very basic user....

I have information that looks like this:

Job Number Condition #1 Condition #2

1 X
1

2 X
2 Y

3 X
3 X

How do I get Crystal to only display the job number that meets both conditions? So "If (Job Number) = "Condition 1" AND "Condition 2" ? How do I also get it to display the job number one time instead of two lines?

Sorry if this is broad, but I don't think I should be spreading our numbers around. I tried to explain the best I could!

TIA

 

[Turkbear]

Hi,
The first part can be handled by your seelction criteria formula:

({job number} = "condition1" AND {job number} = "condition2")

If there are multiple records with that job number, try grouping on the job number and place the info about the job in the details of that group.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Dehalo212]

Thanks!

 

[lbass]

Are the conditions separate fields?

Insert a group on Job and then go to report->selection formula->GROUP and enter:

maximum({table.condition1},{table.job}) = "X" and
maximum({table.condition2},{table.job}) = "Y"

-LB

 

[Dehalo212]

Thanks for the reply bass. They are seperate fields. I am not sure what you mean by ({table.condition1}. Maybe if I use an actual example that may help.

Job Number Impression Bindery
0xxxx B&W
Saddle Stitch

0xxxx Color
Saddle Stitch
0xxxx B&W
Corner

So I would want to display only those jobs that are B&W and Saddle Stitch, and would want them to display on a single line.

I'm sorry I am trying my best to explain my issue!

 

[lbass]

In your last example, you are not showing actual job numbers, so I can't tell whether these are three different job numbers or just one. Use your Impression field as condition1 in my formula, and your bindery field as condition2.

-LB

 

[Dehalo212]

Geez, I'm retarded. I should of specified that those are different job numbers.

I appreciate all your help by the way!