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 :)
|