Summarizing the data of Repeating Table across multiple Form instances - InfoPath Dev
in

InfoPath Dev

Summarizing the data of Repeating Table across multiple Form instances

Last post 03-22-2012 09:39 AM by alberta. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-22-2012 02:54 AM

    Summarizing the data of Repeating Table across multiple Form instances

    Currently we have this need, we would like to add up the Nth row of a Repeating Table of EACH instance of one Form, and use it as the Nth row of a Repeating table inside another Form, could we accomplish this without coding? or worst case using XPath? To help illustrate what we want let assume each row only has one column:

    ===============================================================

    Form1(FORMA Template)  -> RptTable001  ->Row1: Value 11; Row2: Value21

    Form2(FORMA Template)  -> RptTable001  ->Row1: Value 12; Row2: Value22

    ===============================================================

    Form3(FORMB Template)  -> RptTable002  ->Row1: Value 11+Value 12; Row2: Value21+Value22

    Thanks 

     

  • 03-22-2012 09:39 AM In reply to

    Re: Summarizing the data of Repeating Table across multiple Form instances

    Hmm, now I remember "SharePoint is a flat data structure and does not support repeating elements with a row", in the promoted field for that column of Repeating table, the value would be Value11&Value21 and Value12&Value22 already...Feels like we need to deliminate them in some way and then break them apart before sum them up....pretty tough chore.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.