Posts

Showing posts with the label BIP for-each section

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

BIP for-each section

There were lot of threads going the BIP user forum, for resetting the name numbers. thought simple sample would help them to achieve that :) create a sample report as follows. Use the Ms word , option of putting the page number in the MS word page header. then in the page create a simple xml like this, <root> <page> <name> page 1 </name> </page> <page> <name> page 2 </name> </page> <page> <name> page 3 </name> </page> <page> <name> page 4 </name> </page> <page> <name> page 5 </name> </page> </root> use this syntax <?for-each@section:root/page?> <?name?> <?end-for-each?> merge the rtf with the xml, you can notice that, the report contains, 5 pages, with the all pages having the page number as 1. How does that happen ? for-each@section:root/page , this syntax is going to reset the page every time it find a new root/page node. in this exampl...