cschnell Posted June 20, 2018 Share Posted June 20, 2018 I'm trying to rebuild a report that used to be written manually in Word. That report had a table in the middle of page 1 that listed multiple orders and then had a break for other data and finally was continued on page 2. Some of the orders are single line some are multi line. So the first page may have 1 or 6 orders depending on how much room they take up. The rest basically overflow onto page 2. My task is to reproduce these reports exactly, but I don't see how to exactly do the "continued" portion of the table. I can basically "split" the tables through the query using limits and offsets. Similarly I can split the table based on the number of rows using an expression, but the extra lines don't go into the next group.However, both solutions are estremely limited because if the first table has one or two multi line entries the others get pushed under the data that is between these two tables and the second table, starting at a specific offset won't pickup those "hidden" entries. I think the biggest problem is because I need to use groups to split the pages to have the rest of the data other than the table.Group 1 Header 1__________________________|Table 1 | Order 1 |Price|| | Order 2 |Price|| | 2 Line 2| || | Order 3 |Price|| | 3 Line 2| || | Order 4 |Price|__________________________Other field information half the page (hidden lines 5 and 6 behind these )Group 2 Header 1__________________________|Table 2 | Order 7 |Price|| | Order 8 |Price|| | 8 Line 2| || | Order 9 |Price|__________________________Other field information half the pageSo is there any way to limit a table simply by its height. So basically Table 1 would only have 3 items and table 2 would have 6 in the above case. Or if the orders were only single line the first table would have six and the second only 3? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now