Hi,
I am working on this report which has got item numbers and lot numbers. An item number can have 2 or more lot numbers. Each lot number has a sub-report. What I wanted to do is to set a page break on each item number which I succesfully done it by putting a formula in "New Page Before" (not onfirstrecord).
Now I have this standard text that I put in GH section together with the item numbers. My problem is this standard text shows in every page which I don't want to. To make it clearer, here is an example...
ITEM NUMBER: 00001234
LOT NUMBER: 00121A
Sub-report
"Standard Text"
----
ITEM NUMBER: 00005678
LOT NUMBER: 00141B
00151C
Sub-report
"Standard Text"
------
I managed to separate these two item numbers, ITEM-1 in the first page and
ITEM-2 in the 2nd/3rd page. But because ITEM-2 has two lot numbers and 2 subreports, it didn't fit in 1 page so this "standard text" shows in the 2nd and 3rd page. I only want this in the 3rd page, at the end of the 2nd lot number's sub-report. I want the result to be like this...
PAGE 1
ITEM NUMBER: 00001234
LOT NUMBER: 00121A
Sub-report
"Standard Text"
PAGE 2
ITEM NUMBER: 00005678
LOT NUMBER: 00141B
Sub-report
(no standard text)
PAGE 3
LOT NUMBER: 00151C
Sub-report
"Standard Text"
----
Can you please help me out on how to do this?
Thank you so much :)
IP Logged
