Hello,

I am providing the solution I implemented to deal with this problem.

I created logical fields to coorespond with the text fields; i.e., if I have textfield1, I created logicalfield1. Next, when I saved the data entry form that had the text field on it, I filled the logical field with either a true or false, depending on whether the text field had data entered. Next, I went to crystal, updated the report database, then put a suppress formula to either display or not display the text field and title, depending on whether the logical field was true or false.

Hope this helps someone else.

>Hello,
>
>I am preparing a report in Crystal 8.5 Developer from a SQL table. There are several text fields in the table. Sometimes, the text fields contain data, other times, they are empty. I want to suppress the text fields in the report when they are empty.
>
>Suggestions on how to do this since text fields do not show up in the formula editor?
>
>I should mention that in the report, I have placed a title over each field. When the field is empty, I also want to suppress the title.