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?
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.
1. Following is a blog gives us a good demo to create a SQL Server report using InfoPath form as data source.
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.
TechNet Community Support
2012年3月15日 12:10Report builder can use the SharePoint list as a datasource, if the fields in the form are published to the list.
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.
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).
- 已标记为答案 Emir LiuMicrosoft Contingent Staff, Moderator 2012年3月23日 2:52