Line space in report 1

[keepingbusy]

Hi,

Hope I can explain this suitably and to simplify it I've changed the field names:

I have a straight forward report with Page header, Detail and Footer bands. In the Detail band are several fields from a dbf, one of which is called "NAME". On the Print when tab the setting Print Repeated Values is set to no. To the right of the "NAME" field is another field called "ADDRESS". Under the "ADDRESS" field is another field called "TELEPHONE".

The Print when tab for the "TELEPHONE" field has a few settings, Print only when expression is true and Remove line if blank.

So how this works is that you could have a set of records linked to "John Smith" but the name will only appear once (Print repeated values set to no), there could be more than address, there could be more than one telephone number.

However, when all records for John Smith have been printed, I need a blank line to separate the next name and linked records as above.

The report works perfectly so I'm guessing only a minor tweak is required here guys.

Thank you in anticipation of your advice.


Lee

 

[keepingbusy]

Forgot to mention, using version 9.

 

[Dan Freeman]

Create a report Group on the name expression. Once you have the band for that group, make the group footer band the height you want between each name (group), but with nothing in it.

 

[keepingbusy]

Thank you. Will try that out and post back.

 

[keepingbusy]

Hi Dan

Thank you for the advice. Problem has been resolved by using your suggestions.

Lee

 

[Dan Freeman]

Thanks for posting back! Glad you got it working!