Create report from Infopath form submitted to shareopoint library

Question

Do I need to use

Option1: Sql Server reporting service to generate report from the form published in sharepoint library? If so can you share some documents that I can use to built the report. How will the user access the report?

or

Option2: Also can I insert webpart to the form library to built the report? What webpart do I need to add? Users will search student name and form name to see the form list.

Answer 1

Hi ChitraSaha,

1. Following is a blog gives us a good demo to create a SQL Server report using InfoPath form as data source.
http://nishantrana.wordpress.com/2010/05/26/infopath-forms-and-sql-server-reporting-services/

2. We need to create a custom web part to generate the report. If you only want to see a form list filtered by student name or form name, we can add filter web parts like text filter, SharePoint list filter web part. To add multiple filter sto a data view/list view web part, we can follow this blog to pass filters as parameters to the web part.
http://msdn.microsoft.com/en-us/library/cc300163(v=office.12).aspx

Best regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 2

Report builder can use the SharePoint list as a datasource, if the fields in the form are published to the list.

---

Mike G.

Answer 3

Hi Mike,

Does that mean that infopath form needs to be published to sharepoint list rather than library? Do you have a good doc that describes this process.

Answer 4

Sorry, I use the terms list and library interchangeably; though, so does Reporting Services. When you create a Reporting Services report, you can choose to use a "SharePoint List" as a datasource. And, by "list", they mean list or library (or form library).

http://denglishbi.wordpress.com/2011/04/13/using-sharepoint-list-data-for-reporting-services-ssrs-parameter-source/

---

Mike G.