Hi everyone

I am using crystal report 8.0.1.0. i am getting all data in report as i desire.

i am displaying all records as given below order in report.

company name:
contact person:
address:
p.o.box:
zip code:
phone no:
fax:
email:

ok i am getting records as i want but if is it possible that suppose there is no data of phone no and fax.

then i want to be displayed data in reports in same order but there should not be any space between zip code and email as given below.

company name:
contact person:
address:
p.o.box:
zip code:
email:

after zip code there must email bcoz there is not data for phone no and fax.
if there is data for this then it should be displayed.


waiting for reply.

Best regards,
ASIF

As far as I know, you would have to create a formula field with many iif's. Something like:

iif({Table.companyname}<>"","Company name: " & {Table.companyname},"") ....

etc etc for every one.

____________________________
If you find the answer helpful, please mark this topic as solved.