Pagination.
How many rows are returned by my query.
Add a column already in the query and edit the Formula max(rcount(1))
Now assuming each 'page' of output is 25 lines, how many pages of output are there: once again
Add a column already in the query and edit the Formula CEILING(max(rcount(1))/25)
We are busy paging through our report and want to know how many pages in we are:
Add a column already in the query and edit the Formula CEILING((rcount(1)-1)/25)+1
Remember you can cast the output as INTEGER and that will ensure that the output is integer and not double (doesn't show the .00).
No comments:
Post a Comment