Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2008

Tip: Looking for answers? Try searching our database.

Pivot repeating table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bjorn - 18 Apr 2008 11:26 GMT
Is there a control like the repeating table that I can pivot? For example, I
want to asak about the number of employees in a company by their gender and
contract type. The underlying data structure is something like:

(Gender, Contract Type, Number)

In fact, there are only 2 values for gender (Male, Female) and 3 values for
contract type (owner, unpaid famliy member, paid worker). This means, the
respondant may only give 2x3=6 values for the number of employees.

So, the repeating table control is a good solution to be able to enter these
up to six records. But, the most often taken solution for display of the
table is to pivot it and display the values for sex in the table header as
column names and contract type as the first column. Again the values for the
contract types already filled in. The respondant only need to fill the 6
figures for the number of employees. The control will automatically take care
of filling the records into the underlying table (i.e. unpivot the answers so
to say).

Does such a pivot repeating table control exist? Thanks in advance!
Clay Fox - 18 Apr 2008 15:11 GMT
Hi Bjorn.
There is not a control for this but often you can simulate this to the user.

You can have multiple repeating tables and format one one way and one the
other.

If your data was in a database you could create multiple views.
Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> Is there a control like the repeating table that I can pivot? For example, I
> want to asak about the number of employees in a company by their gender and
[quoted text clipped - 16 lines]
>
> Does such a pivot repeating table control exist? Thanks in advance!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.