Sometimes, in real business of web report, the volume of data may be very huge. Then, when reading, displaying and exporting the report, problems like low speed, memory overflow, and system crash may appear.
How to solve the problem?
As a professional Java Web reporting tool, RAQ Report
always tries best to make users convenient. RAQ Report provides advanced paging tag extHtml which expands the functions of original Html tag, and realizes reading, displaying, and exporting data by page.
Therefore, it decreases memory footprint, enhances operating efficiency, and avoids memory overflow.
Then, how to display a specific page or several specific pages in cell with RAQ Report extHtml paging tag?
There are two solutions.
1. Supposed that the number of default cache page is 100, set the value of cachePageNum as 1. Input expression “beginRow/20+1” in a cell to display current page number, and input the expression “totalCount/20” in a cell to display total number of pages. If the value of cachePageNum is not set as 1, the value of beginRow will not change, and the current page number will be 1 all the time.
2. Set the data type of a cell as html, and input the js code below to the cell.
Then the current page number will be displayed when clicking “next page”.
Input the expression “=floor(query(‘SELECT count(*) FROM Dataset ’/20,0)+1” in a cell to display total number of pages.
This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog