General

Re: Problem with table headers in repeating table

stara — Wed, 20 Oct 2010 13:12:02 GMT

Shiraz,

I'm using infopath 2003 and I tried to follow your instructions to display table headers on every page. Unfortunately, this doesn't seem to work correctly.

When I view the form, the table header repeat with each record and in the Print preview - Table headers appear on every page. But only 1 record per page is displayed. Here's what I did:

1. A section at the top for page header

2. Added a section below with page break - andconditional formatting "The expression" as:

round(count(../preceding-sibling::my:myFields) div 8) != count(../preceding-sibling::my:myFields) div 8 OR

count(../preceding-sibling::my:myFields) = 0

3. Added a section below with table headings and with conditional formatting "The expression" as:

round(count(../preceding-sibling::my:Products) div 8) != count(../preceding-sibling::my:Products) div 8 AND

count(../preceding-sibling::my:Products) != 0

4. Added data fields below

5. items 2,3,4 are within a repeating section

Can you please help me resolve the issue? I have attached the form.

Thanks a lot,

Stara

Re: Problem with table headers in repeating table

AzuDaioh — Wed, 28 Jul 2010 23:08:04 GMT

Is this doable for Infopath 2003 sp1? I can't open the attachment from Shiraz so I'm hoping there's an earlier version. The example shown with templatepart:header and templaatepart:footer with the repeating section in the middle is exactly what I need for my form so I could include the company's logo and official form number on the bottom. It sad that the footer/header option in Infopath 2003 is so limited. I'm almost done with my form except for the print version.... Thanks.

Re: Problem with table headers in repeating table

Hilary Stoupa — Tue, 24 Nov 2009 00:28:50 GMT

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).

Re: Problem with table headers in repeating table

Meng S. — Sat, 21 Nov 2009 01:39:14 GMT

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?

Re: Problem with table headers in repeating table

Patrick — Tue, 02 Sep 2008 17:20:29 GMT

Awesome Greg! Thanks, that works perfectly

Re: Problem with table headers in repeating table

Greg Collins — Tue, 02 Sep 2008 16:22:44 GMT

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

Re: Problem with table headers in repeating table

Patrick — Fri, 29 Aug 2008 21:47:30 GMT

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.

Re: Problem with table headers in repeating table

GLazkano — Tue, 24 Jul 2007 14:25:10 GMT

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.'

Re: Problem with table headers in repeating table

Shiraz Cupala — Mon, 23 Jul 2007 15:42:15 GMT

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.

Re: Problem with table headers in repeating table

GLazkano — Mon, 23 Jul 2007 15:31:18 GMT

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.

Re: Problem with table headers in repeating table

GLazkano — Fri, 20 Jul 2007 10:43:47 GMT

I'll try that as soon as posible.

Thanks again!

Re: Problem with table headers in repeating table

Shiraz Cupala — Thu, 19 Jul 2007 19:35:26 GMT

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.

Re: Problem with table headers in repeating table

Shiraz Cupala — Thu, 19 Jul 2007 16:31:10 GMT

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

Re: Problem with table headers in repeating table

GLazkano — Tue, 10 Jul 2007 07:47:36 GMT

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.

Re: Problem with table headers in repeating table

GLazkano — Tue, 10 Jul 2007 07:09:20 GMT

Thanks, I will try it inmediatly!