Browse Products
Browse Categories
Support
Resources
SharePoint® does not currently provide an easy way to work with popular reporting systems since all SharePoint list data is in the same database table. Field names are generic, making it difficult to retrieve information. The SQL View Web Part is especially useful when users have the need to build and run ad-hoc reports. A user can take standard SharePoint list data (such as announcements, tasks, events, etc.), automatically create a SQL statement, and turn it into a SQL view or embed it into any ad-hoc report.
The SQL View Web Part generates SQL statements and database views that can be used to combine information from several lists, such as products, orders and customers. This Web Part allows you to create alternative views of SharePoint list data and use them in familiar reporting applications such as Microsoft Access or Crystal Reports, providing data analysis and decision-making benefits for any organization.
New! Now available on SharePoint Foundation 2010 and SharePoint Server 2010.
First, select the site where your list resides, then select the list. You can only see the lists that you have permission to access. The user can then select the fields within the list to be included in the SQL query statement, including external fields referenced by a lookup field. A SQL query statement is generated for the selected fields, which can be copied and pasted to a report tool, or a SQL View can be created automatically in the SQL database to be used by the report tool.
Knowledge Base Articles:
System Requirements:
SharePoint 2007:
SharePoint 2010:
*Note: Bamboo products are not supported in an IIS Web garden configuration.
Release Notes for SharePoint 2007:
Release Notes for SharePoint 2010: