Create reports based on data stored in SharePoint® using popular reporting applications, such as Microsoft® Access or Crystal® Reports.
What Does It Do?
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.
SQL View Web Part vs. SPS, WSS and MOSS Base Functionality
SPS 2003, WSS 2.0
MOSS 2007, WSS 3.0
Bamboo
SQL View
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.
•
Solution deployment now available. Install SQL View on one web front end server and it is deployed to all web front end servers in your server farm. -New!
•
•
How Does It Work?
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.
Why Did We Build It?
SharePoint® does not currently provide an easy way to work with popular reporting systems because 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 into any ad-hoc report.
System Requirements:
Operating System:
Microsoft Windows Server 2003
Server:
SharePoint Release 2:
- Microsoft Windows SharePoint Services v2 or Microsoft SharePoint Portal Server 2003 (with SP1 or SP2)
- Microsoft .NET Framework 1.1, Service Pack 1
SharePoint Release 3:
- Microsoft Windows SharePoint Services v3 or Microsoft Office SharePoint Server 2007
- Microsoft .NET Framework 2.0 or 3.0
Browser:
Microsoft Internet Explorer 6 or greater is recommended for Advanced Administration features
Download Instructions: To purchase the web part or download the trial software,
please add the appropriate product from the table below into your shopping cart and proceed
through the check out process. You will have to register and create an account in the
storefront so that we can send you the download email. There are no payment, shipping charges,
or taxes on the trial download. Once you receive our email, you should be able to download and
install the software within minutes. Make sure you download and refer to the application notes
for detailed installation instructions.
Installation Instructions:
Complete installation instructions and an usage guide for this
web part are included in the Application Notes below. Please make sure you download and read
them prior to installing the web part. In addition to the Application Notes, potential
installation problems are also documented in our Web Part Deployment and Security FAQ, which
can be downloaded here.
Bamboo Community Site:
Please visit our community site where you can read more about our products. Community support, questions and feedback can be founded in
our online forums.
Support Instructions:
Please email us at
support@bamboosolutions.com
and visit our Knowledge Base for additional information on bug fixes, enhancements and release
notes at http://store.bamboosolutions.com/kb/.
Our support hours are
from 9 AM to 6 PM US EST (GMT-5), and 9:00 to 18:00 Central Europe Time
(GMT+1). For more information about our support plans, visit our
customer support page.
Your Thoughts:
Your feedback on this web part is important to us as we
make every effort to meet your needs. Email us at
sales@bamboosolutions.com.
Thank you!
Your feedback is extremely important to us. To ask a question about this product, please click on the "Post a New Message" link below. To suggest a new feature or vote on current feature suggestions, please click here. To submit a bug report, or request product support, please log in to My Bamboo and click on My Tickets.
Recent SQL View Web Part - Release 1.3 Forum Posts
List with lots of columns (2 replies) - We have a list that contains 11 date time fields, now according to MS, SharePoint stores each entry in this list in morethan 1 row in the unerlying SQL table with an ordinal incremented. The...
At Bamboo Solutions, we are constantly innovating, always improving our products to serve you better. Help us improve this product by suggesting a feature enhancement, or just by voting on the ideas other customers have proposed. Your feedback truly guides our product development effort. To report a suspected bug, rather than suggest a new feature, please click here. Use our product forums for additional questions, please click here.
Product
SKU
Description
Price
Order
Server License
HW04.R1.3.SL
Software, Release 1 - per server license.
$300.00
Trial Download
HW04.R1.3.TD
15 Days Free Trial Download
FREE
Application Notes
HW04.R1.3.AN
Application Notes provide detailed information, including examples of how to use this Web Part.
FREE
Basic Annual Support
HW04.R1.3.SB
Basic technical support provides up to 3 incidents per year, with 2 business days response time. Free maintenance service pack releases. Valid for 1 year from the date of purchase.
$60.00
Premium Annual Support
HW04.R1.3.SP
Premium technical support provides up to 6 incidents per year, with 4 hours response time. Free maintenance, updates, minor and major releases. Valid for 1 year from the date of purchase.
