Remove lines in fields

[bbprecise]

I'm trying to modify a report in our ERP software (with Crystal Reports 2016). In the attached screen shot I have 3 lines circled. Is it possible to remove these lines or have N/A automatically inserted based on the the value in the WC/Vendor field (on the left of screenshot where it says "QC PLAN")? We have many WC's (work centers) that don't require the "Man 1st PC", "CMM 1st PC", and "Completed" fields filled out. What we've done in the past is the engineer hand writes in N/A when they aren't needed but it's a lot of work. If we can remove those lines based on the value in the WC filed, or have N/A put in automatically it would save a lot of work and time.

Thanks.

[Kevin_Ford40]

Would be helpful if you also show the area designed in the report to help us determine if the lines are drawn or part of a field that has been dropped in to provide additional help

[H_Lo]

Hello,

Yes, you can either hide those lines or display "N/A" conditionally, using a formula.

If that's a line you've drawn in Crystal reports, you can: right click on it and click 'Format Line', look for the X2 button next to a Suppress checkbox. In here you can write a formula to check the value of the WC field. e.g., something to the effect of:

{field}* = "QC Plan" Or {field} = "OKU"

This will hide the line when those values appear in the WC field. 

Alternatively, you can create a formula that displays "N/A" based off the value of the WC field. To do that you can go to the field explorer, right click on Formula fields, click new, give it a name, and enter your formula. You'd want something like:

If Not IsNull({wcfield}*) And ({wcfield} = "QC Plan" Or {wcfield} = "OKU") Then

 "N/A";

You can then drag and drop the formula into your report.

*just a placeholder to demonstrate, you'll need to select the field from the Report Fields dropdown at the top of the formula editor.

[bbprecise]

I'm not sure how the lines are inserted in to the report, but I'll give this a shot. Thanks.

[Kevin_Ford40]

Would be helpful if