Hello Janet,
You can split the fields in separate details (Section Expert window - insert).
For instance:
You have FirstName, LastName, Address fields in Your report. FirstName and LastName are always definied but the Address is not a mandatory field. In this case You create 2 deatails. Put the FirstName and LastName in the first one and the Address in the second one. Set 'Suppress Blank Section' on the common tab (in the Section expert window) for the second detail and there should not be any blank field, if the Address is not defined in the datasource.
Hope this helps :o)
Have a nice day and happy weekend!
Gabriel
|