Hi,
I have a report layout that consist of before.field, detail layout and after.field. There is a unique PO# in before.filed for each report print out and aech PO# has a group of items and there have a signature field at the after.field. Only 10 items will be printed on the detail layout for each PO#, if there are more than 10 items then the next item will be printed to the next new page and the after.field must be printed on the bottom of the report.
Can some one help??????

Thanks:;)

Hi,

Check Nd (Need) field in Maintain Report Layouts. The number indicates how many lines are needed for the layout on the same page. If it equals 0 , only the number of lines of layout itself are taken into account.

I hope it helps,

- George

Hi again,

You might want also to check your report script for the "need() function". You can read about it here:
http://www.baanboard.com/programmers_manual_baanerp_help_report_scripts_functions_in_report_scripts

- George

Hi,
OK, Thanks I will check and read about it.....:D

Thanks
swan

Hi,
I had already read about the link that you gave to me n tried the need() function in the report script but it is not the result that I want........
Maybe my question is not clear.....sorry.....Actually what I mean is.....I have a paper format that I need to print my report layout on it n the paper format is fixed (cannot be adjusted) so I need to adjust my report layout on ERP LN to fit my paper layout. Below attachment is my report layout on ERP LN n paper format screenshot.....help?????? :confused:

Thanks!!!!!!

Hi,

If you have checked that Nd field and also made sure that you do not have "need()" in your script, go to Maintain devices and check the page length of the device you are using, try to increase it and print again.

- George

Hi,
I found that there is no "Need" field in Maintain Report Layout but have "Extra Need" field in Maintain Report Layout. I had checked the "Extra Need" field n try to increase or decrease it but still also the same problem that is the after.field.2 layout at the bottom print based on the no. of items in the detail field. If the detail field has 10 items then the after.field.2 will print at the bottom of the page n if the detail field has 1 or 2 items then the after.field.2 layout will print at the top of the bottom page :( Help???????
May I ask that the page length for a A4 size paper???????

Thanks

What is the Page length you are using in your device? Go to Maintain devices (ttaad3100m000) and check the page length of the device you are using.

Hi,
I use Display device to view the reprt layout which the page length is 66. But use Windows device which the page length is 0 to print the report on paper.

Normally the page length used for printing on Preprinted stationary is obtained from the actual paper length..........using Custome option for paper....

For skiping after 10 Detail lines and printing the data for after.field section .............you need to play with your layout.........

Creat a footer record with the details of after.field section , and make sure that that footer is printed only in case when u have more that 10 detail lines........else make the print condition false................u need to reset the condition for every page ...

Please let me knw if the above logic makes sense to you....
or do you want more details.

Hi,
Thanks you, loveubaan.....but can I have more detail????? How to play with my layout to meet my condition and if I have to reset the condition for every page then it will be a bit difficult right? coz i dont know how many page will it be print out for each report??????

example :

before.field.1:
before.layout:
footer.print = false
count = 0

detail.1:
before.layout:
if count => 10 then
footer.print = true
count = 0
page()
endif

after.layout:
count = count + 1

footer.1:
before.layout:
if not footer.print then
lattr.print = false
endif

after.field.1:
before.layout:
if footer.print then
lattr.print = false
endif


this is just an example for ur reference .............plz let me knw if it helps u...........just give it a try............its not that difficult....

Tricky but not difficult part is ahead ---- Printer Setting.....

Hi,
Thank you.....I will try it....thanks :D

Hi,
Yeah........:) It's work. Thank you very much, loveubaan
Thank you so much!!!!