Repeating tables and SharePoint Form Library

[PW]

We have a form with repeating tables that is stored in a SharePoint Form
Library. To report on the data we use another Infopath form to query the
data published to columns in the SharePoint library. SharePoint/InfoPath
seem to be limited in ability of querying this repeating table data. Does
the form data need to be stored in SQL to create reports that look at each
individual repeating table entry?

 

[Tausif]

Storing data in SQL does make it easy to query.
I am facing a similar situation with the repeating tables data getting
stored in sharepoint.
Are you familiar with VBA in Excel ? I am working on a macro which will
split out the repeating data into seperate rows in Excel which can then be
used for reporting.
Typically, you would use the split()
eg) Split(rngToParse, Chr(10), , vbTextCompare) Where rngToParse is the
Excel range.
I am almost done, will post the code in couple of days, but to give you a
heads up,
1) Download the SP data in Excel.
2) Use VBA code to split the data. (Split() & Chr(10) is the key here)

Cheers,