SUPRESS you stupid line, SUPPRESS

I've got a Crystal Report in my application that can be printed in one of two ways.

The first way is to print a blank report. When this report is printed, certain questions on the report have multiple lines for users to answer the questions on.

The second way pulls the information from a database and displays it on the report.

The problem I'm having is with the second way. When the report prints with information that has already been entered, I don't want the lines to print out after the questions. I want the data field to grow and not have 2 or 3 lines drawn on the report with nothing on them.

How can I suppress the lines when the report is not blank? I've tried messing with the suppress property of the lines, but I get a "Permission Denied" error. Anyone ever tried to hide fields/objects based on the values on the report?

with in the formula editor for the suppress,

Code:

---

If length( {drag your data field form the list of report objects and drop it here} ) > 0 then True
Else
False

---

Close & save it.

I understand completely what you are saying, I'm just having a little trouble getting there.

I designed the report thru the VB IDE, not Crystal Reports itself. How do I access the formula expert for the Suppress property of the line? If I can get to that point, then hopefully I can resolve any other issues that pop up.

Thanks.

Over on the left hand side of the screen will be a gray area with a listing of all the groups and detail sections.

Right Click on the one you want to be supressed, and, seeing that you want to use a function to do this, go into the "Format Section..." option.

As soon as that properties window opens up, one of the checkboxes over to the right will say Suppress next to and have the "Function button" on the other side of it.

Click that button and code away (dont actually check the box though, that will forcefully suprress it always).