Report - Print When & Remove Line if Blank

[WayneBecker]

I am using the same "Print When" expression on all the fields in the "Detail" line of the report. I am also using the "Remove line if blank" tick box. When the report is printed I get a four page report including the 18 lines that meet the criteria. The rest of the lines on the report are blank! Any help would be appreciated.......Wayne

 

[DEDMOD]

Are there perhaps some character fields with " " or the like in them?

Dave Dardinger

 

[WayneBecker]

Thanks Dave for the prompt reply. The criteria I'm using is on a character field but I'm using Print When - "VAL(inform.mint) >= 1"

Thanks......Wayne

 

[DEDMOD]

I'm no expert on reports. The ones I've created are generally created via wizard. I was just playing with one I've got in a project and it was working fine when it comes to deleting empty lines. I have two fields and set two separate 'when' conditions which made some of one field not print and some of the other not print and the preview of the report shows only ones where at least one of the conditions gives a non-empty field.

I'm not sure what you're doing wrong. What version of VFP are you using? Hopefully someone more expert on reports will come along and help you.

Dave Dardinger

 

[marsh]

Try:
1) not empty(inform.mint) int the print when box
and/or
2) have you checked ALL the "remove lines when blank" and put the print when clause in each box of the the detail line?