Adding horizontal lines to a report 1

[Bryan - Gendev]

My app has 2 reports. The one I am concerned with has per record an area of multiple fields with each record separated by two horizontal lines. I get 4 records neatly on an A4 page.

Now I have a request from a user to make a change which will best be satisfied by adding a field at the bottom of each record block which will expand only when the underlying field has data in it.

This works fine with one annoying problem.

My horizontal lines at the end of each record do not print at the end of the additional field but in the original place thus writing right through my new field if it has content.

like this :-

Previous last field label | Previous last field content |
________________________________________________________ (I can't make overtype work here but here would be the first line of the new field ( unlabelled ))
________________________________________________________ second line of new field content
third line etc etc

Is there a way to get these record separator lines to print below the new field if it has data in it?

Thanks

GenDev

 

[Mike Lewis]

A quick thought off the top of my head:

Add two lines to the report. Use one of them for when the underlying field is empty, the other for when it contains data. Then use the Print When condition in each case to decide which of the two lines to print. So the first line has a Print When that prints when EMPTY(<the underlying field>), and the second line does the opposite.

On reading this back, the solution sounds too simple, so I assume I must have misunderstood the problem. Or have I?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

I'd say you could tackle this with the general options of these lines and instead of fixing them to the top (default), choose "fix relative to the bottom of the band".

Bye, Olaf.

 

[Bryan - Gendev]

Thankyou Mike and Olaf

Olaf's solution was spot on.

One lives and learns....

GenDev