The table with my data contains a (manufacturer's) code.  I want to display the name--which I am obtaining from another table.  I am doing an outer join because there isn't a 1 for 1 matching.  There are some instances where the code doesn't correspond with a name--but it does correspond with another field in the table that has the name.

Currently, my report is displaying a line with the name and the appropriate dollar amounts in each column.  There are 2 examples where the manufacturer's name isn't found or displayed.  In those cases, the name on the line is blank.

What I want to do is create a condition to bypass the blank name.  Something to the effect of:
if {pmf_display} is null then .....

The tables are outer joined on the code (pmf_id) but the code in the main table can be joined to a different field (pmf_acct) in the name table.  So, I also tried:
if {pmf_acct} = 'AGG' then 'Agg' else if {pmf_acct}='CRN' then 'Crn' else {pmf_display}

No matter what I do, I get BOOLEAN errors.  I'm sure it is a simple fix (I can easily do it in any SQL editor).  I just need to figure out how to do it in Crystal Xi.

Thank you.  That seems to get me halfway there.  I can control the display there but I (somehow) need to edit the join to control the display.  I realize that isn't very clear. 

In simplified terms, we are tying to display the sales volume by manufacturer.  The general ledger ("GL") contains a manuf. code (pmf_id) which I am joining to the manufacturer table.  But, in some cases, the code in the GL doesn't match the code in the manuf. table.  That is because some manuf. codes are grouped into categories.  So, when the manuf. code (pmf_id) in the GL doesn't have a corresponding pmf_id in the manuf. table, I use the pmf_acct field (the group) in the manfu. table.

In SQL, in the SELECT section, I can use the CASE functionality to display pmf_id when it exists (isn't null) OR ELSE use the pmf_acct code (or even further clarified, such as CASE WHEN ISNULL(pmf_id) THEN WHEN pmf_acct='AGG' THEN 'Aggregate' ELSE WHEN pmf_acct='CRN' THEN 'Crane' ELSE pmf_display END END).  I don't know how to do that in Crystal.

When I create the formula field, I am using "if isnull({pmf.pmf_acct}) then {pmf.pmf_acct} else {pmf.pmf_display}" but that doesn't change anything.  If I change the statement to remove "{pmf.pmf_acct}" and replace it with something like "AGG" then "AGG" appears for all blanks (not just the ones that it should.d  So, I know the ISNULL part is correct.  I think the problem goes back to my join statement.

so you have a NULL match in the gl join field, correct?

Again, adding the formula field (and replacing the display with the formula field) of
if isnull({pmf.pmf_display}) then {pmf.pmf_acct} else {pmf.pmf_display}

doesn't change anything from before adding the formula field.  BUT, if I replace "pmf.pmf_acct" with (say) "ABC", then my 2 blank lines show "ABC".  So, I am partially there.  I just need the pmf.pmf_acct part to work.  Again, I think the issue is the join.  The line is blank when it didn't find a join.  Therefore, there is no pmf_acct to put there (likely the reason the field is blank).  I may be able to hard code it by saying if pmf_display is null then  IF pmf_id='AGG' then 'Aggr' else if pmf_id='CRN', then 'Crane' else pmf_display.

That should work.  Then, if there are any other codes (pmf_id's) that don't correspond, I will get blanks for those and then can edit the code when they occur.