https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/16503.aspxFri, 22 Dec 2006 07:34:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16503Patrick Halstead0https://www.infopathdev.com:443/forums/thread/16503.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=16503Hi Susy and welcome to our forum!<br />That's correct and this is one of the major limitations of SharePoint. It only supports flat lists. The merged list is essentially a concatenated string and that's why you can't sort them. You could use our Database Accelerator to shred to SQL and create an SRS view on top of it that sorts the elements in your collection, but that's probably another week or two of work for you.https://www.infopathdev.com:443/forums/thread/15504.aspxSat, 16 Dec 2006 07:39:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15504Susy0https://www.infopathdev.com:443/forums/thread/15504.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15504I have created a safety reporting system in Infopath (multiple reports/views) and published it to a SharePoint form library. In my form I am using a repeating table for Participant Details (name, team, dept.). When I submit the form, the contents in the repeating table are merged and very nicely put in seperate rows in the SharePoint library. So far, so good.<br />However, when I want to sort or filter one of these merged columns in the SharePoint library, the system wont let me. Apparently, I cannot sort merged fields (makes sence, but is very frustrating). Is there any way to do/fix this? Reporting to management and thus the success of this reporting system depends on finding a solution.