Crystal Mandatory Fields

Hiya,

I'm writing a crystal report linking with an Access Database.

basically I need to say If Address line1 = "" then display section A if not, do nothing,

but I have to do this for about 30 fields, How would i go about doing this?

Basically, it picks up data from the database,If everything is filled in when the report is run, the report orints out fine, if something is blank or a null value then it will pick up details section B which will say "The following fields need to be filled in" and then it will list the fields?

Any ideas

Thanksif you want to suppress whole section A if addressline ="" then right click on section A -> format section -> there is a button beside suppress text click on it and write down:
if addressline ="" then true else false

It will suppress that section and if you want to suppress some fields only then you have write this on each and every field in design view and for that you have to right click on that field -> formate field -> and here also same you have to write "if addressline ="" then true else false" in suppress button script.

Best of Luck|||better use

if isnull(addressline) then
true
else
false