{"id":2151,"date":"2011-05-30T19:12:18","date_gmt":"2011-05-30T11:12:18","guid":{"rendered":"http:\/\/www.finereport.com\/knowledge\/design\/%e7%94%a8java%e6%8a%a5%e8%a1%a8%e5%b7%a5%e5%85%b7finereport%e5%ae%9e%e7%8e%b0%e6%8c%89%e7%85%a7%e5%9b%ba%e5%ae%9a%e8%ae%b0%e5%bd%95%e6%95%b0%e5%88%86%e9%a1%b5.html"},"modified":"2018-09-11T19:38:56","modified_gmt":"2018-09-11T11:38:56","slug":"pagination-fix","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2011\/05\/30\/pagination-fix\/","title":{"rendered":"Java reporting tool with a fixed number of records FineReport achieve pagination"},"content":{"rendered":"<p>In pagination preview the report or print the report came out, often require a fixed number of records paging, making it more convenient to browse the report, print it out and more beautiful. Use &#8220;condition attribute&#8221; FineReport <a href=\"http:\/\/www.finereport.com\/en\/products\" title=\"reporting tool\">reporting tool<\/a> functionality can easily achieve this effect.<br \/>\nHere to introduce <a href=\"http:\/\/www.finereport.com\/en\/products\" title=\"Web Reporting Tool\">Web Reporting Tool<\/a> FineReport achieve a fixed number of records in accordance with the detailed procedure paging.<!--more-->\u3002<br \/>\n<b>1.Reports template design <\/b><br \/>\nIn the following figure in the report, requires each of which has six rows records, and each page has a fixed record last used for sales representatives to sign<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix1.png\" title=\"Reports template\"><img src=\"http:\/\/www.finereport.com\/CN\/wordpress\/wp-content\/uploads\/images\/pagination-fix1.png\" alt=\"Reports template\" class=\"centered\"><\/a><br \/>\n<b>2.Set the repeat header row <\/b><br \/>\nWhen the web page preview or print a <a href=\"http:\/\/www.finereport.com\/en\/products\" title=\"web report\">web report<\/a> page, so that each page has a title line display for easy access. In FineReport Report Designer, right-click the first row, select &#8220;Set repeat header row&#8221;, the first line will appear (H) of the mark, as in Figure 1.<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix2.png\" title=\"repeat header\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix2.png\" alt=\"repeat header\" class=\"centered\"><\/a><br \/>\n<b>3.To count the number of records <\/b><br \/>\nWrite the formula = &#038; B2 in cell A2, the number of records that is used to give the order number count<br \/>\nCustomermize cell A2 is &#8220;up and down expansion,&#8221; and left the parent grid of &#8220;B2&#8221;<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix3.png\" title=\"the extended properties set\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix3.png\" alt=\"the extended properties set\" class=\"centered\"><\/a><br \/>\n<b>4.Get the number of records <\/b><br \/>\nWrite the formula = A2 in cell A3 to get the number of records<br \/>\nCustomermize cell A3 is &#8220;up and down expansion,&#8221; and left the parent grid of &#8220;A2&#8221;, as shown below<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix4.png\" title=\"extended properties set\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix4.png\" alt=\"extended properties set\" class=\"centered\"><\/a><br \/>\n<b>5.Set the report of condition properties <\/b><br \/>\nRight-click cell A3 and select &#8220;Condition properties&#8221;<br \/>\nWhen you add a &#8220;conditional property 1&#8221;, set the current record when A3 acquired value is a multiple of 6, then a &#8220;line after paging&#8221;, as shown<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix5.png\" title=\"extended properties set\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix5.png\" alt=\"extended properties set\" class=\"centered\"><\/a><br \/>\nWhen you add a &#8220;conditional attribute 2&#8221;, set the current record when A3 acquired value is not a multiple of six, perform the third line &#8220;row height is 0&#8221;, that is the signature line that displays only the last page, as shown below<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix6.png\" title=\"condition properties set\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix6.png\" alt=\"condition properties set\" class=\"centered\"><\/a><br \/>\nIn this case, the final report template as shown below<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix7.png\" title=\"report template\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix7.png\" alt=\"report template\" class=\"centered\"><\/a><br \/>\n<b>6.Report final results preview<\/b><br \/>\n1st page\uff1a<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix8.png\" title=\"Report preview\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix8.png\" alt=\"Report preview\" class=\"centered\"><\/a><br \/>\n2nd page\uff1a<br \/>\n<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix9.png\" title=\"Report preview\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/pagination-fix9.png\" alt=\"Report preview\" class=\"centered\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In pagination preview the report or print the report ca&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2151"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=2151"}],"version-history":[{"count":1,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2151\/revisions"}],"predecessor-version":[{"id":4744,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2151\/revisions\/4744"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=2151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}