SQL View Web Part

Product info:
Developer: Bamboo Solutions
Designed for: MOSS 2007, WSS 3.0, SPS 2003, WSS 2.0
License: Per server

SQL View Web PartThe SharePoint 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.

With the SharePoint SQL Web Part you can:

  • Build a SQL query statement from any list starting from the top-level site, and all its sub-sites.
  • Retrieve field information from joined lists through lookups.
  • Automatically create a view in the SQL database.
  • Install SQL View on one web front end server and it is deployed to all web front end servers in your server farm.


HowIt Works: 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.