This then that??? HELP!

[Yustrn]

Here is what I'm looking for, I'm doing a report in Crystal version 7.


I am using Tax fields and what I need is a formula that will look into the listing of employee's taxes and will pull out the tax description 4 (I have 8 tax fields to choose from) like (Ca-State), but if that field is empty, then I want it to use the state in their regular address field and if that is empty then just leave it blank. Both of these are choices within the table, I'm just not sure on what to use for a filter. I appreciate all answers.

 

[dgillz]

If Not (Isnull({Field1})) then {Field1} else if not (IsNull({Field2}) then {Field2} else {Field3}

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Ngolem]

I will try a more complete formula....it really depends on what you mean by "empty"...is it null or full of blank spaces

will pull out the tax description 4 (I have 8 tax fields to choose from) like (Ca-State),

this makes no sense at all.

1. is "4" a number or cyberspeak for "for"
2. are you looking for the value of the employee's state?
and it is possible to find it in 8 tax fields that can potentially have this value? If so and two fields are not null, which value would you select?? or do you have a order to your acceptable choices?

explain better please...

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!