Skip to main content

Is there anyone can help me to display 5 line items on the first page of the report then sixth or next line item will display on the next page of the report

The only way I can think about resolving it is making the section size static which could inconsistent results unfortunately


@jhan47 

Have you tried different settings for the report sections around the “Keep Together” and “Page Break” options?

I’m not sure which report you’re using and what the exact requirements and set-up is, but this may help.  As far as I know, there’s no way to specify exactly 5 records, then a page break.  But if you have things that need to be split between different record types or groups, the page break option may help.  Keep Together will try to keep everything from that group section on the same page, if it fits, otherwise the section may be split across multiple pages.
 

 


Thank you so much guys I used the keep together behavior and adjust the printing location so the next line item will print on the next page


Hello guys I have a follow-up question can i add the qty of line item if the line item have the same inventory id?

 


I’m not sure which report this is from and what tables you have, but if you’ve got multiple line records for the same inventory ID, you should be able to get the quantity value as well (usually from a table like POLine or SOLine or something similar)


It is came from SOShipment line


Create a variable to count the records at the detail level such as:

=$LineNbr+1

Then create a grouping with the following formula: 

=Ceiling($LineNbr/5)

Then you could put a page break on the grouping above.

 


Reply