Conditional Formatting-help the noob 1

[tinyredtornado]

Please excuse this ridiculous question- I have signed up for a class but it's not until early January!!!I am trying to create an if then conditional. My experience with crystal reports has thus far been using an excel sheet as my database and simple drag and drop report creation. Currently, I have 2 fields stacked on top of each other in the report, x on top of y, as they want both fields to show in the same column. If x (which has 2 values, pass and fail) is not pass, then show field y underneath x. If x is pass, show field z underneath x. Please take pity and help me begin my education while retaining my job...sorry for this oh so simple question and thanks

 

[smcnulty2000]

There is more than one way to do this, and I think others may chime in with their favs.

Mine (and no doubt others would suggest) :
Make a new formula.
In the formula:

if {fieldx}="Pass"
then {fieldy}
else {fieldz}

Then place this formula under x.

When posting here, doesn't hurt to include your Crystal version. Sometimes you are just slowing the process down because we'd have to ask anyway.

Not a ridiculous question, just basic.

 

[tinyredtornado]

thank you very much- I am using crystal 2008-trial version as we haven't decided on the version we will purchase, based on the client's pocketbook

Bless you. If you ever want to go sailing in San Francisco you get a free ride on my finance's boat. Cheers!!!
saillola.com

 

[tinyredtornado]

saillola.com
jeezus no wonder I have problems, I can't even spell my own url

 

[smcnulty2000]

No big. Thanks is plenty. Anyone here is pretty much happy to help or they wouldn't be here.

Bring more questions. We like them.