Crystal Reports

Re: FORMULAS IN CRYSTAL

Peter Doonican — Tue, 07 Jul 2009 14:58:58 GMT

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

Re: FORMULAS IN CRYSTAL

David Gillman — Tue, 07 Jul 2009 14:37:37 GMT

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.

Re: FORMULAS IN CRYSTAL

Laurel Quaintance — Thu, 25 Jun 2009 19:23:00 GMT

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

Re: FORMULAS IN CRYSTAL

Yuriy Iordakiev — Thu, 25 Jun 2009 19:17:26 GMT

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

Re: FORMULAS IN CRYSTAL

Laurel Quaintance — Thu, 25 Jun 2009 19:11:51 GMT

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

FORMULAS IN CRYSTAL

Erin White Terrell — Thu, 25 Jun 2009 18:30:27 GMT

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?