Repeat Table Header in all pages in BIP

how to repeat the column titles on a table in all pages if the table extends over several pages

What you need to is:

1. Select and Highlight the table header row
2. Right click and select table properties
3. On the Row tab properties , specify that the header row should be repeated on every page
4. Save the RTF
5. BIP looks at the properties of the word settings for the table and will repeat the header row on every page the table needs.

This works so well in PDF output, but RTF output seeems to have some issue with this header repeat functionality
We all can beleive, In future releases this bug won't be there ;)

Comments

Arave said…
What has worked for me when building an rtf template is the following.
Step 1. split the table so that the headers become their own table and the detail becomes its own table.
Step 2. set table properties for the row of headers to so that the header row should be repeated on every page
Step 3. set the table properties for the detail row(s) so that they do not repeat as header on the next page.
Step 4. Remove the table split made in step on so that there is one table again.

This worked in my specific case as MS Word was not enabling me to correctly set the repeat table headers on next page...
Sat Jan 17, 04:18:00 AM 2009
cwskid said…
Thanks. Your suggestion worked for me.
BI Template Builder 5.6.3, MS word 2007
Sat Sep 19, 04:23:00 AM 2009
Rajeev De Silva said…
Both the solutions worked fine for me....Thanks alot..
Wed Sep 02, 09:59:00 AM 2015
Unknown said…
I have a header value which is in a loop in RTF template, which can change based on the value of that field in the loop. It needs to repeat across pages, so I have enable 'Repeat across pages' option. But when it goes to a new page, it prints ALL the values for the header in the loop before printing the Detail section. Can anyone advise on this issue?
Tue Mar 17, 12:32:00 PM 2020
Post a Comment

Popular posts from this blog

BIP Formatting

Image
Adding formatting is easier in BIP. It can be done manually or automated through menu. How to add the BIP formatting manually,  here is an example. Just add the logic and the formatting you needed. How to add the BIP formatting through menu,  here is an example. use the Menu and choose conditional formatting You have to select the data filed and choose the menu option conditional format
Read more

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
Read more