KimSharp
16th February 2007, 01:16
We have BOL report that someone customized several years ago but it has never lined up with our preprinted BOL form. I'm trying to get everything aligned correctly and it's the first time I've tried to modify a report. I got the header and the details printing where I want them but no matter what I do, I can't get the footer to print in the correct position. I want it to print at the exact bottom of the page. It's 7 lines long. I want the 7th line to print at the last line of the paper or at most one line up from the bottom. It's a standard 8.5X11 page, printed on a dot matrix printer. Another clue. If I set the report size to 66 which I believe it should be, the footer prints on the second page. I have to put it to 60 to get it on the correct page.
pellus
16th February 2007, 10:56
What I would do, to start with, is to temporary customise the footer layout to print the line number attr.lineno, on the last footer line. The I see what line no it is. The the pagelength for the report = this value.
jp.aalders
16th February 2007, 12:58
Has the function "skip to(spool.pg.length - [x]) been used in the reportscript?
Using this function you can start the footer at the desired position calculated from the bottom of the page. The calculation uses the setted page length to calculated the correct position ( see form 2 of maintain reports ).
KimSharp
16th February 2007, 16:54
but I'm really new to this and I'm not sure how to do what you're suggesting. I've seen the skip.to command suggested here and that does seem like what I need, but I'm not sure how to use it. So far, I've only edited the report with the Baan client interface and that doesn't seem to offer a skip to functionality. I can open the script but this is all I get. It doesn't look like everything that prints in the report since I don't see the footer so I'm not even sure if it is the correct script. If it is, where would I put the skip.to function?
|******************************************************************************
|* tdsls442102000 VRC B40C c3 prod
|* Bill of Lading (Not Cash on Delivery)
|* train1
|* 08-30-99 [15:30]
|******************************************************************************
declaration:
extern string refer.a(30)
extern string customer.po(30)
before.foco.1:
before.layout:
select tdsls040.*
from tdsls040
where tdsls040.orno = :tdsls043.orno
order by tdsls040.orno
selectdo
customer.po = tdsls040.eono
refer.a = tdsls040.refa
endselect
detail.1:
before.layout:
select tdsls041.item from tdsls041
where tdsls041.orno = :tdsls043.orno
and tdsls041.pono = :tdsls043.pono
selectdo
endselect