Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Salve! I have a handful of subsites, each with a form library that uses infopath content-types. The user creates a new form document in a the library and then fills out the form.

I want to gather the data from those completed forms (from every subsite) into a single list (on another site) where I can see all the data entered. I know how to use a CQWP to get a list of the forms (based on content-type), but that doesn't get me a list of data.

I want to see something like this:

form1   field1value  field2value
form2   field1value  field2value

A fellow in one of the answers here speaks of doing this in a DVWP, but I think that this doesn't exist in 2010; a fellow here speaks of it being called XSLT List View Web Part, but when I go to "Insert Web Part" in my Page, I don't see that web part listed.

What can I do? Any ideas?

[update]

I asked a separate question here about how to get a DVWP, and received a splendid answer.

share|improve this question
add comment

1 Answer

called XSLT List View Web Part, but when I go to "Insert Web Part" in my Page, I don't see that web part listed.

"Insert Web Part" option lists already published (deployed) to Shaqrepoint webparts.
XSLT List View Web Part is for being created designed dynamically based on a data source content.

You can do it from browser but if you do it from Sharepoint Designer 21010 (SPD), you will clearly see its markup or tag XsltListViewWebPart as well as its code.

So, in SPD create a WebPart page (Site Pages > there are many ways how to further do it, quite obvious.

There, in Design view, in a placeholder I usually insert a few line breaks in order to be more comfortable with further editing.
Then click Insert tab, on ribbon > DataView > choose a (document) library under Documents and Libraries section of dropdown list of choices.
Then, you will clearly see WebPartPages:XsltListViewWebPart

You can repeat it inserting other XsltListViewWebPart web part.

Though, answering your title question, you most probably will want to make first a specific/separate data source.

IMO, Sharepoint is good for simple OOTB gathering of data but not its (or "their, I am not good in English) flexible (or advanced) management (and presentation). If you want to manage efficiently and dynamically, on the fly, (large amount of) data then you most probably should use Database Management System like MS SQL Server, here are some keywords from MSSQL:

  • MS BI - Business Intelligence
    • SSAS - MS SQL Server Analysis Services,
      • DM - Data-mining
    • SSRS - MS SQL Server Reporting Services
      • etc.

Update:
Now, after answering, I've noticed that the question is tagged with "infopath", though, IMO, Infopath is quite unrelated and divergent to XSLT List View Web Part usage

I want to gather the data from those completed forms (from every subsite)

You should promote fields to sharepoint fields during form template publishing in order to be able to easily access the same data from sharepoint fields.

In Infopath Designer, you create data connections/sources to sharepoint (form or doument) library or list, insert controls for fields and links them (with Xpath) to whatever field data from whatever source you wish in any combination.

share|improve this answer
    
Gennady, this is a good answer; you get my vote - however I will have to try it out before I mark it solved... The question was tagged infopath because the data to be listed was generated from an infopath form content-type and resides in a form-library; some folks might think that is an important detail. –  BGM Nov 21 '12 at 3:06
    
BGM, thanks. I did not pretend (and would have never dared to attempt) to answer your title question (because it is multi-facet interweaved with many unknowns business and system analysis project assignment), I had an answer to your body question which was too lengthy for a comment. I would have felt more comfortable if you've had different questions in different posts. –  Gennady Vanin Novosibirsk Nov 21 '12 at 4:05
    
Well, my title question reflects what I really want; my body explains how I have attempted to get there. Folks always dig for details. I don't care what way to do it, I just need to do it somehow, which is why the question was broad. –  BGM Nov 21 '12 at 15:14
    
I do not see any problems to do what is asked in the title. And there are a zillion variants how to do it but I am not going to bloat by them my answer. Note that your question is formulated ambiguously... For example, how to choose which of the Field1Value to show in first line (for form1) and in second line (for form2)... What is the problem in showing values from different forms - just bind controls to secondary/receive data connection/source? –  Gennady Vanin Novosibirsk Nov 21 '12 at 16:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.