zhgello
6th February 2009, 18:08
I have created a report. The layout contains a Header with the order number and also a Detail with position, item, quantity information.
The idea is that I want each page on the report to show a different order number, with detail about that order underneath.

The problem is that when I print a range of orders the following happens:
Page 1
Header (for order 100001)
Detail (for order 100001)

Page 2
Header (for order 100001)
Detail (for order 100002)

Page 3
Header (for order 100002)
Detail (for order 100003)

So the Detail is correct for each page. But the Header of Page 1 is always repeated on Page 2. And then the Header for each successive page is always off by 1)

Can you provide any guidance?

BaanInOhio
7th February 2009, 04:23
Copy your 'header' layout to 'before.field' for the order number field, then remove the header that you copied. This ensures that the "header" gets the new order number each time it prints.

kishoremeher
8th February 2009, 09:03
first in input field, set the order field as assending or descendiing.
then create a before.field.order layout and ticked the page checkbox .
this will work out.

zhgello
13th February 2009, 21:33
I still do not understand why data was repeating in the Header layout.
But using the 'before.field' works in this case.

Thank you.

baan.kmurali
17th February 2009, 13:39
the header layouts will be printed at the top of the every page.
So 1st goto "maintain input fields" and make the orderno as ascending order..save it and then goto "maintain report layout", you can copy(select header layout and click the copy button) the header layout to "before.layout" and enter the order name as a filed name of "before.layout" .
i can try it will work

i got it