I am trying to replace a number of

[swc123]

I am trying to replace a number of formulas using hardcoded logic.
Grouped on FLD,
If FLD = "joe" then "Joe Adams"
elseif FLD = "pete" then "Pete Rose"
else "Unassigned".

I would like to use a reference table and then print the Full Name from that table. I'm ok for those in the Table, but am not sure how to process those names which are not in the table.
Steve

 

[synapsevampire]

You'd end up using a formula something like:

(note that if you set null values to default you can omit the isnull() check in the formula)

if not(isnull({reftable.name})) and {reftable.name} <> &quot;&quot;
then
{reftable.name}
else
If {Maintable.Name} = &quot;joe&quot; then &quot;Joe Adams&quot;
else
if FLD = &quot;pete&quot; then &quot;Pete Rose&quot;
else &quot;Unassigned&quot;

Or use a case, little less effort involved:

if not(isnull({reftable.name})) and {reftable.name} <> &quot;&quot;
then
{reftable.name}
else
CASE {Maintable.Name}
WHEN &quot;Joe&quot; THEN &quot;Joe Adams&quot;
WHEN &quot;Pete&quot; THEN &quot;Pete Rose&quot;
ELSE &quot;Unassigned&quot;
END

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[swc123]

Thanks, got your note in the other re-submit.

I'll have to test around some, but would I,
a) Link the tables under Database (maintable.shortname & reftable.shortname) -- this should get me JoeAdams, PeteRose, etc.
b) Use the logic with isnull you have above
finally,
c) elseif &quot;unassigned&quot;

I'm hoping to use the table for most, then Unassigned when it's not found.

 

[synapsevampire]

A) Right
B) Right
C)I'd use a Case rather than IFs, but as you point out, my IF conditions weren't correct.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

Have I missed something?

There's nothing wrong with the original Else condition or syntax Kai supplied, if we're talking about Crystal syntax. Elseif is basic syntax.

Naith

 

[chelseatech]

I've got a Text file lookup UFL. It loads the Text File into memory and then you can search the rows for values.

Sort of like the VLookUp in Excel. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[swc123]

Thanks all.