InfoPath Dev

I have a Data Source using an Access database and and need to display one of the columns horizontally across the InfoPath form. Do you have an example of how this can be done. The table contains 4 columns...Control Account, Budget Element, Date and Dollars. I need Date to be listed horizontally accross the page and Dollars to be listed under each date.  I would like to do this using a repeating table.

Since you are using IP03, there is no built-in way to do what you want. However, you can do some manual edits that will allow you to do this with a repeating section (not a repeating table).

1. Create a repeating section of a fixed width with two fields in it: Date on top, and Dollars below.
2. Then extract the form files to a folder (from the File menu), and close InfoPath.
3. Edit the view .xsl file and locate the new section you created. It will be in an xsl:template. There will be a <DIV/> tag set around the contents of that section. Change the DIV to a SPAN.
4. Save and exit your text editor.
5. Right-click the manifest.xsf file, and choose design.
6. If you had an XSN before, you can now save your template back as an XSN.

I have to format several columns of data from an Access table horizontally accross a page.  The above option works for a couple of columns but not for all the ones I need.  Is there a way to do it with arrays?

There is no simple way to do this in InfoPath. InfoPath likes lists--not arrays, and can repeat list items vertically or horizontally. You might have luck creating your own ActiveX control to deal with arrays. I don't have any experience with custom controls, though I know they have limitations within InfoPath and that you should be able to find examples on the net somewhere.

If you want, you can contact Patrick Halstead directly about hiring his company (Qdabra Software) to build such a control (if it is possible -- which I cannot of myself say whether it is or not).

Sounds like your just getting 5 columns of a table which should be straight-forward.

If I understand your diagram correctly, your XML DOM might looks something like:

<TableName controlAccount="" budget="" element="" hours1="" hours2="" hours3=""/>

Repeating of course. Then a simple repeating table should give you what you want.