[Pb] print fixed rows per page in datawindow

Source: Internet
Author: User

Print fixed rows per page in datawindow

Step 1: Add a calculation column, which must be placed in the detail segment. Input in expression:
Ceiling (getrow ()/20) <-- here 20 can also be replaced by a global function, which allows you to set the number of rows printed on each page at will.

Step 2: define the group and select rows> Create group...
Group by calculated column fields and select Check box --> new page on group break.

Step 3: set this calculation column as invisible.

In addition, if the last page is not enough to fill in blank lines. It is also very simple, as follows:
Long ll_pagerow = 6 // number of lines printed per page
Long ll_count, ll_row
Ll_count = dw_report.retrieve (...) // obtain the total number of rows in an existing report
Ll_count = ll_pagerow-Mod (ll_count, ll_pagerow)
If ll_count <ll_pagerow then
For ll_row = 1 to ll_count
Dw_print.insertrow (0) // fill in blank lines
Next
End if

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.