Help in Detail section of Crystal reports.

[sudarshan73]

Hi, i am new to crystal reports and i would very greatful and thankful , if you could please help me how to do the following.

I have the following fields in the details section
AddressName
Add_Line_1
Add_Line_2
Add_Line_3
If there is no data in Add_Line_2 i want to print Add_Line_3 in the position of Add_Line_2 & accordingly and not leave a blank line in between and if there is no data in Add_Line_3, instead of printing a blank line, i wanted the detail section to dynamically reduce/adjust the height of the detail section and move up the fields if there is no data, so that there won't be odd line spacing between multiple address.Please help.

Thanks
Sud

[sudarshan73]

Can somebody please help or advise .....

[brucevde]

Use mutliple detail sections. Add a new details section for Line 2 and one for Line 3

There is an option to "Suppress Blank Section" but I find it does not work that well. If it does not work for you then use the Suppress formula of the section to determine whether to print or not.