We are using a subreport for a Packing List. There is one item, quantity of over 900, each with its own LotSerialNbr. When printed from the subreport, all of the LotSerialNbr’s print on one long sheet of paper and we would like to break that up into at least two or more pages. I’ve tried using “Keep Together”, “Page Break” to After, Before, BeforeAndAfter, including a =’Page: ‘ + [PageOf]] in the subreport pageFooterSection1.
Answer
LotSerialNbr's over running on with no page breaks
Best answer by lauraj46
Hi
Understood that you need the subreport to paginate. Sorry, the example that I created didn’t have all of the serial numbers on the same shipment line so it was a poor test. With the changes that I posted the subreport should paginate, but it could be that you’re running into issues because the field in the subreport won’t split across pages. For that, make sure that the field in the subreport has CanSplit = True.
It’s hard for me to create a test example with so many serial numbers. Give it a try and let me know.
Hope this helps!
Laura
+8Hi
Subreport pagination can be fussy. The following advice has worked for me:
- Place the subreport in a separate section, with a little bit of space between the subreport and the section borders.
- Set the KeepTogether property on the section to False
- Set the PageBreak propert on the section to After
Hope this helps!
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
Still the same thing, all of the LotSerialNbr are showing up on one long legal or bigger page.
+8Hi
Interesting. I’ve personally run into this issue several times. The instructions that I provided are based on the post below:
If you’re still having issues, please upload your rpx file and that might help with troubleshooting.
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+8Hi
I tried to download the Zip file but I’m getting an error. Can you upload the rpx files instead?
Thanks,
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
+8Hi
Try putting the subreport in s separate section with no other controls, and a little bit of space around the subreport control. Also, be sure to set the Keep Together property on the new section to False. Let me know if that works.
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi lauraj45,
Tried the subreport in other sections, including groupHeaderSection4, groupFooterSection3, detailSection3 all were negative (in all three the subreport did not send back any data), along with other sections which had the same result of an elongated overflowing page.
Hi lauraj45,
Is there maybe a way to set up pagination based on a count? In this particular case, there are 960 LotSerialNbr’s associated with one item. Maybe there is a way to have a counter for let’s say about 100 or 150 then page, next 150 then page etc. Just a thought.
+8Hi
You also need to turn off KeepTogether on the footer section of your subreport. I updated both of these reports (attached), and tested it with a shipment. The serial number paginated correctly. Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi lauraj46,
The report does paginate, but the subreport, since it has 1,344 LotSerialNbr’s prints out page two with like super legal paper, all on one sheet, all 1,344 numbers with no page breaks. I apologize if I wasn’t clear on the requirements, but we are attempting to print on a standard 8.5in x 11in size paper for the Packing List unless I am missing something. I appreciate the help though. Any other suggestions?
Thank you.
+8Hi
Understood that you need the subreport to paginate. Sorry, the example that I created didn’t have all of the serial numbers on the same shipment line so it was a poor test. With the changes that I posted the subreport should paginate, but it could be that you’re running into issues because the field in the subreport won’t split across pages. For that, make sure that the field in the subreport has CanSplit = True.
It’s hard for me to create a test example with so many serial numbers. Give it a try and let me know.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi lauraj46,
It worked, it worked, it worked. It’s not really very pretty, but it is functional and it is splitting the page into sections. Your suggestions about the Subreport: View PDF, TRUE, the field on the subreport, in the groupFooterSection1, CanSplit = True, Main Report: detailSection1 band where the subreport resides, Keep Together False, no PageBreak. I certainly hope someone else can use the same settings as what you suggested and I want to thank you for your time and help on this. Stay safe. 😊
William J Matthews
+8Hi
So glad you finally go this working! Hopefully this thread will be useful to others as well.
I reside in Ohio where it’s just cold today. I share your hope that everyone in this wonderful Acumatica community is staying safe 😊!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
I reside in Florida, where it’s not too cold today. Yesterday was chilly, but bearable. I love this community as that is what life should be about, sharing and caring about others. I’m still a fledgling from the SQL community, so a lot of the differences still takes time to get used to. Again, thank you for the help, and I don’t mind sharing the knowledge with others.
William J Matthews
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.