I'm a crystal novice - so this might be a breeze for lots of you here.

I have created an sql query that contains all the information I need for my report.
This sql query contains a "part number" and a "customer catalog number".

I thought I should create a formula field that would print in the Details section of my report.

I thought I would create a formula field called "partnumber" with a formula that went something like:

if IsNull({CATALOG_NUMBER]) then {PART_NUMBER} else {CATALOG_NUMBER}

So, basically, if the catalog_number is blank, return the data in the part_number field - else - return the data in the catalog_number field.

But this just doesn't seem to be a syntax that Crystal likes.

Am I even in the right area?

Does anyone just have one bullet? Just one. For me.