Does anyone know how to complete the following statement in crystal formula editor if a is not equal to b then display a and b if a is equal to b do not display it?

wouldn't the supress duplicates function do the same thing?

I'm not getting it. Do not display what?

I realize I wasn't specific. If you go to the details portion of your report, right click on the field you want click format field, go to the common tab and check supress if duplicated

I think your logic would need to be like this if A <>B then "A" else if A=B then null in cognos impromptu which is similar to crystal this will only return the value A if A and B are not equal otherwise it will return a null.

As long as you do not want to use the field you are trying to suppress in a summary or grand total another option would be to right click on the field in question and then on the Common Tab click x-2 and the pencil next to Suppress and in the forumla editor enter

a=b

Save and close, the x-2 should now be x-2

Peter