Hiding data fields

[Drus]

How can I hide only certain data fields? In other words, is there a formula (i.e. "no show&quot that can be used to hide a field when the information contained in that field shows a specific result?

For example, I have a Crystal Invoice form that I want to show if the field contains a "/C" or a "/M", but anything else should not show on the invoice at all.

Thanks,

 

[rogar]

Right click on the field and select Format Field to bring up the Format Editor. On the "Common" tab, click the "X-2" button to the right of "Suppress" This brings up the "Object Visibility Format Formula Editor" Enter a formula for the condition when your field should be NOT visible, e. g.
Instr(yourfield},"/C&quot = 0 AND Instr(yourfield},"/M&quot = 0

Save and close your formula. Your field will be condtionally suppressed when the formula evaluates True.

 

[dgillz]

Do you want it to "not show" or do you want it to be excluded from the report altogether?

"hiding" or suppressing a record does not excludeit from any subtotalling or grand totaling on the report, and those totals will not reflect the sum of oyu r visible records.

If you do not want these records to total, scrap the above suggestion and put similar logic in your record selection formula. Then all "selected" records will be visible and no other records will evaluate in sub and/or grand totals.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Drus]

That helped greatly. Thanks. However, it would suit my database a little better if I were able to show the exceptions. In other words, I would like everything to be suppressed except "/M" and "/C".

Any suggestions,

You've been more than helpful.

ahagenbach@opus-sys.com