Hi,

I have a report that consist of before.field, detail field and footer field
and PO# is a sorting field in before.field. Let's say i want to print my PO report from PO#1 until PO#10 but how to print the footer field on the last page of every PO#. Right now, my footer.field printed on each page of every PO( PO#1 until PO#10) and this is not i want. Help???????????????

Thanks
swan

Hi,
U can most probablly use after.field to print the footer after each PO#. If i am not wrong u want each PO# on new page.

Hi,
Ya, u r correct that i can use after.field to print the footer at every last page of new PO# but after.field could not print the footer at the bottom of the page. It is only print after the detail layout......but i want it to print at the bottom of the every last page of new PO#.......Help!!!!!!!!!!!! :(

Thanks

Hi,

Then you will have to use a footer, and define a boolean variable to decide wither to print the whole footer or not. The following link should help:
http://www.baanboard.com/baanboard/showthread.php?t=50225

- George

Hi,
But the link that u gave to me is discuss about hiding field and now i want to print the footer layout at the last page of every new PO#!!!!!!
Help!!!!!!!!

Thanks

Hi,
user can choose to print the PO items by select the PO# inrange, for example choose PO#1 until PO#10 to print the items in report. But do anyone know how to dump the different PO# to a separate report ( so there are 10 reports with different PO# will be print out concurrently) so that each report will have a footer........print at the bottom of each report but not each page of report ( 1 report only have a footer at the last page of a report). Do anyone know how to do it??????? Help :(

Thanks

Hi,

If you read it carefully you will find how to hide the whole layout ;)

- George

Hi,
Can u please specify ur requirement again. Like do u want the same report to be printed separartely for each PO# so that each report wil display the details of a single PO#, or u want each PO# to go on the new page.
If u want the same report to be printed separartely for each PO# then u may use brp.open separately for each PO#.
OR if u want each PO# on the new page then u can tick "New Page" check box in the before.field

Hi rahul.kolhe22,
I want the same report to be printed separartely for each PO# so that each report will display the details of a single PO# and so that each PO# will have a footer at the bottom of its last page report.
Sorry, can I ask you for more details on how to use brp.open separately for each PO#??????:confused:

Thanks!

Hi,

You need to write report script:

declaration:
extern domain tcpono tmp.pono

footer.1:
before.layout:
tmp.pono = order.no| table fields whichever u r selecting

and u need to take same field as form field in ur footer layout

Now footer will print different order no on each page

I hope this is what u want.

Hi saumya,
This is not what I want......What I want is.......the footer will only printed at the bootom of last page for different PO#.....Help!!!!!!

Thanks

Hi Layswan,
If you want each PO# details in a seperate report and footer at the bottom of the last page, then you can use a boolean variable which will be set when all the details of a PO# in printed. The same variable you can specify in the Print Condition for that layout i.e. footer.

For the details of brp.open() you will find it in progguide.chm. Even I know only what is given there not more.

Hi rahul.kolhe22,
I want the same report to be printed separartely for each PO# so that each report will display the details of a single PO# and so that each PO# will have a footer at the bottom of its last page report.
Sorry, can I ask you for more details on how to use brp.open separately for each PO#??????:confused:

Thanks!