HI all,

 got another question I have a crystal report in VB.NET and it displays an address of a customer line by line but not all of the customers have all of the lines filled with data therefore it somtimes look like this

Name : Microsoft
Address 1 : 11 Silicon Valley
Address 2 :
Town : LA
Country : USA

my question is how can I hide a field from CR if there is nothing in it so the gap does not appear on the report

What you can do is to conditionally suppress the field:
Right-click the field, click 'Format Field...' and select the 'Common' tab.
To the right of 'Suppress' you'll find a formula box. Click it and use a
formula like: {Table.Cust_RTyp} = 1, Report Type 0 - To print all & 1 - only for name and city (supress Addr.)

Gokulan Ethiraj

Sorry but I dont know much about formulas and I do not understand what is the formula you have writen here means