Remove a line in a report.

[sdocker]

I would like to remove a line in a detail band if it is blank. It is the second line of a 2 line detail band.
There is only this 1 field on the line and I checked the "Remove line if blank" in the format property.

Thanks,
Sam

 

[Mike Lewis]

I checked the "Remove line if blank" in the format property

That should work. But are you sure the line really was blank? Is it possible that the field contains spaces?

I suggest you try setting the field's Print When condition to NOT EMPTY(<field name>). Or, alternatively, set its expression to ALLTRIM(<field name>). Or both of the above.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

Is there something below that single field? It's also sometimes a riddle to me, what the report engine handles as a "line" of a band. It may be too close to other report controls to really be seen as the only element of it's line. I'd also check band properties, maybe "constant band height" is checked.

Bye, Olaf.

 

[sdocker]

Sorry, I meant " I checked the "Remove line if blank" in the PRINT WHEN property.

In the interim, I seemed to have answered my own question:

I put this lone field in a second data band.

Thanks for reading. Sorry to bother.

Sam

 

[sdocker]

Thanks Olaf,

There was nothing below that single field and it was not too close to the field above it. Constant band height is NOT checked.

As I mentioned, all seems to be working fine now.

Thanks again,

Sam