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 / July 2004

Tip: Looking for answers? Try searching our database.

Merging nonrepeating fields? Please help!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
astrujic - 02 Jul 2004 12:37 GMT
Can I merge fields in nonrepeating secrions? For example if i have "number of loans" box on form (in non repeating section),... on merged form, I wanna in same "number of loans box" box show a summary value from from all merged documents
Jerry Thomas [MSFT] - 02 Jul 2004 18:06 GMT
One way is to put the Number of Loans in a Repeating section but then set
the section properties so that the user cannot Insert or Delete sections.

Then you can have another field or an expression box with the expression:
sum(my:NumberOfLoans).
As you merge the forms, this will total the values in the repeating node.
This can be done in a seperate view so that the repeated (merged) fields
aren't seen.

Signature

Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias.  This alias is for
newsgroup purposes only.

> Can I merge fields in nonrepeating secrions? For example if i have "number of loans" box on form (in non repeating section),... on merged form, I wanna
in same "number of loans box" box show a summary value from from all merged
documents
astrujic - 05 Jul 2004 12:11 GMT
This will do it. Thank you

> One way is to put the Number of Loans in a Repeating section but then set
> the section properties so that the user cannot Insert or Delete sections.
[quoted text clipped - 9 lines]
> in same "number of loans box" box show a summary value from from all merged
> documents
Greg Collins [MVP] - 02 Jul 2004 18:48 GMT
You can write custom merge code that will do this.

What I'm not positive about is whether you can write custom merge code for only a portion of the DOM and have InfoPath perform the defualt merge on the rest, or whether, once you choose to do a custom merge, you have to write the merge code for the entire DOM. Does anyone else know the answer to this?

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

Can I merge fields in nonrepeating secrions? For example if i have "number of loans" box on form (in non repeating section),... on merged form, I wanna in same "number of loans box" box show a summary value from from all merged documents
 
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.