I need to create a report that will emulate what our warehouse uses as a “Pick Ticket” for pulling orders. The user wants to enter multiple ID’s that represents different orders, and have returned a page that can be printed for each order. Some orders will have multiple pages, i.e. 1 of 4 pages.
In the database, we are reusing columns such as Quantity01, Quantity02, etc. For the 11th product, we are populating the Quantity01 field for the 2nd time. This is done each time we go beyond the 10th product. The problem I have been facing is, when using a table, it tries to grow automatically to accommodate the 11th product and so on. I have found a way, using the Page break option, to force the results to the next page after the 10th product. The problem with this is the change is only effective for the middle section of the report. The top section and bottom sections do not push to the next page.
As far as I can tell, I cannot use headers and footers b/c of how the user wants to run the report. If you pass more than 1 order ID into the report, it will populate the middle section with the appropriate order items, however the header and footer values will continue to populate the values from the first order ID it comes across. I could have the expressions in my fields wrong as well.
I need to be able to create one page that looks like the screenshot [attachment uploaded], and force it to populate the correct order values in the middle section per page, up to 10 products per page then move to the subsequent page until all pages for that one order have been completed, as well as when a new order ID is encountered, start the same process again.
I have been able to trick it to do so if I am processing only 1 order ID at a time.