Controlling output in a multi-column report

[1421]

Hi All!

I am printing a report using 3 columns (the same data is printing 3 columns accross, as i set it up in page setup). To show the data so that each column is properly seperated i include a vertical line. this vertical line shows up after each column, i am trying to find a way not show this line after the third column of data, as i dont need to show a seperation. I coded in 'print when' _pcolno<40 and that did not do it (all 3 still appear). Any suggestions?

Thank You

 

[Mike Lewis]

1421,

An interesting question.

Testing _PColno definitely won't work. In a VFP report, it always returns 0.

The only solution I know is to move the vertical line way over to the right-most edge of the column. With a bit of care, you should be able to place it so that, for the right-most column, it falls into the unprintable margin at the right side of the page, but it still shows up for the other columns.

Give it a try.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Stella740pl]

Hi Mike,

You beat me up to this.

I've just did about the same in my 2-column report, and it worked.

I put the line to the right of that line that is bordering the column from the right (the one that shows up in the Report Designer, but not in print or preview), so it is actually placed in the spacing between the columns. This way, it doesn't print after the last column. Even a pixel to the right from the column border into the spacing works fine.

 

[Mike Lewis]

Hi Stella,

Yes, I just tried it as well, and I saw a similar result.

The exact behaviour might vary with the printer, as different models will have slightly different unprintable areas. But at least we know it's feasible.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Stella740pl]

Mike,

I think it's doesn't necessarily has to be an unprintable area.

From what I've seen, it just should be an area not within the column, but in the spacing.

This can be taken care of in the "Page Setup" dialog.

A little tinkering with column width and spacing size, with the following placing the line outside the column and into the spacing area will take care of that, and you don't need to drive the line into the unprintable area.

This works just because "spacing" exist only between the columns, and after the last one it is not "spacing" any more.

 

[1421]

Thank you all

Your advise worked!...as I am working on this i just recieved a package that i ordered AppDev training CD-Rom on Foxpro. We are here to stay!!!

Thank You!