Surpress Blank Fields

[RachelK]

So far I have a formula that goes like this. I do not want the blank fields on my report what do I need to add to this formula to say If "" then don't put the field im my report.

If Left ({SYJOBTRN.JOB},1 ) = "N" Then {SYJOBTRN.JOB} Else
If Left ({SYJOBTRN.JOB},1 ) = "A" Then {SYJOBTRN.JOB} Else ""

 

[HowardHammerman]

First make sure that in your File | Report Options dialog box you have checked "convert null fields to default".
Then put the formula on your report, right-click and pick 'format field'. then click on the 'x+2' button next to 'suppress'. Put in the following formula:

length(trim({@formula})) =0

Substitute your formula name for @formula above.

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[RachelK]

Thanks for the response. I finally managed to sort it by using the select expert starts with A or N I don't know why I didn't think of this early but it's only my 1sr week using crystal.