Posts

Showing posts with the label BIP Row Fillers :)

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below

Row fillers in BIP.

Some thought about the report, where Tim sir himself has explained thousand time, iam doing it for thousand and one time :0) You want to display all the rows continuously and then then if the row end in mid of the page, still you want the total to be displayed at the end of that page. To make you understand better,How to do you say its, at the end of the page. Last page content only in 5.6.2 BIP , we can use here :) The smart way is we can identify how to achieve that is, we got the control of rows running through pages, and if we can decide that a page is going to take 20 rows, that means , 20 th row is the end of the page. So, what you want to decide is , how much row a page can contain, if probably the page is going to take 20 rows, fix as 16 rows, in order to accommodate some expansion in row height due to wrap you worried abt. so, the logic goes here, go with the same approach as the TIM's and then when the row ends, find out how many rows have been printed in that particular ...