InfoPath Dev

Hi,

I'm working in a project with a lot of repeating sections and tables, and I need a print view which show the header of that table after a page break.

I've tried this but it don't work on my project and it return this message:

oDocument.appendChild(oSamplePage.cloneNode(false));

I've tried many other things and nothing works, that's the reason I decided to post this here.

Can anyone help me?

Thanks.
 

Unfortunateyl, there is no way in InfoPath to force table headers to automatically print across pages. It is definitely a deficiency. It may be possible to hack the XSL to do it, but it would be rather risky. There is one other thing you could try if your rows are of fixed height. You could redo the structure as a repeating section with some special logic. Here's what you'd do:

1) outer repeating section tied to your repeating node.

2) inner section #1 tied to or any child node. put a 1 row table in this to have a header row.

3) inner section #2 tied to any child node. put a 1 row table in this with same columns as the header row and put your actual data fields in here.

4) innser section #3 tied to any child node. insert a page break (from insert menu) in this.

5) put conditional formatting on the section #1 to only show if your "position()" is a multiple of say 25 (i'll let you figure out the formula) or if it's position()=1.

6) put conditional formatting on the section #3 to only show if the position is a multiple of 25 - 1 so that the page break comes right before the header.

 This requires fixed height table rows and then you cna calculate it out and get a fairly good approximation of headers repeating at the top of each new page.

I hope this helps set you in the right direction. Thanks.

Sorry but I have still a problem.

I don't know which is the expression to check if a number is a multiple of another.

Thanks again!. 

Update at 16:18  (GMT +1)

I found why it doesn't work: when the form enters in a repeating table, all the content of the fields are shown up, without check the formatting conditions specified on the section. It's like if suddenly all the fields were shown and then (only then) the next section made its job.

I don't know if I'm explaining myself, but I have tried it and It doesn't work. 

Hmm. Well, I wanted to avoid pushing you to have to use code for this, but the following HowTo (complex) also achieves what you want.

http://www.infopathdev.com/blogs/matt/archive/2005/11/29/Repeat-Table-Headers-Across-Multiple-Printed-Pages.aspx

I hope that helps.

Thanks, Shiraz

I have figured out how to make this work. The EXPRESSION you need to use in your conditional formatting is:

For the Page Break Section:
round(count(../preceding-sibling::my:group2) div 8) != count(../preceding-sibling::my:group2) div 8 OR count(../preceding-sibling::my:group2) = 0

For the Header Section:
round(count(../preceding-sibling::my:group2) div 8) != count(../preceding-sibling::my:group2) div 8 AND count(../preceding-sibling::my:group2) != 0

Note it's slightly different for each section so you don't get an initial page break. Also I was wrong about the placement of the page break. Easiest to put it at top above the header. See the screen shot.

The attached example form template demonstrates this technique.

2007-07-25: This post has been edited for accuracy.

I'll try that as soon as posible.

Thanks again!

I've tried it and there is no good news...

For a section wich contains data your example is simply perfect, but as I explained in other reply, I need it for a repeating table. The code made by Matt Faus in that how-to doesn't work in my form, I get an error which was posted as a comment in the how-to, but no one can help me.

I will continue working on your example,  but I have no hope.

If you want I can attach an example of my form, so you can maybe understand me.

Thanks. 

Right. With a repeating table you have to use code. Using a repeating section to simulate a table layout is really the only way to do it codeless. We frequently use repeating sections for table layout because of the greater control possible. You would have to change your form to use a repeating section instead.

I can't attach an example form I made for you, the forum shows me the error message 'You do not have permission to upload or link to files. Please contact your system administrator.'

 All I can say is WOW, nice job Shiraz!!!

I got this working very nicely, with one exception...The column headers and the Table that houses the position() and controls has a gap between them.  It's strange because I compared it to your example and the Size settings for the sections are all the same.  Is there any trick to getting the header section to have no gap underneath?  Also, there is a small gap between each "row" in successive repeating sections when they are added.

For each section, set all the padding and margin values to zero. Also remove the default 1pt white border from around the section.

Awesome Greg!  Thanks, that works perfectly

Hi Shiraz,

 Great post.... but one question... what if you wanted the second page to contain more rows.   For example, 30 rows for the second page and only 8 rows for the first page.  Is this possible?

Experiment with the sample Shiraz attached to his post, but as I recall, you need to change the 'div 8' part of the formulas to 'div 30' (or whatever your requirement happens to be).