Solved

Sharepoint Web Part - SQL

Posted on 2010-11-19
3
473 Views
Last Modified: 2012-05-10
I am looking for a web part that can be configured to access a SQL database.  Instead of just presenting a list of data, I want to be able to have links in the results that allow you to dig deeper with other SQL queries if you click on a particular column in the results.  Does anyone know of a web part that allows this functionality?  All of the SQL web parts I can find just seem to be able to present a list of data from SQL and that is it.

Also, I assume something like this is possible with BDC?  I am licensed for Sharepoint Standard 2010so I dont have a lot of the functionality for that and the Enterprise CALS are really expensive.
0
Comment
Question by:mattpayne59
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 167 total points
ID: 34173811
i have never seen a web part that does exactly this.  your request is pretty customized.

you could use Data View web part as a starting point, and modify it to do as you need.
0
 
LVL 8

Assisted Solution

by:zabiullah
zabiullah earned 167 total points
ID: 34173948
You can integrate SQL Reporting Services with SharePoint to create drill down reports. The following references could be helpful

for 2010:
http://technet.microsoft.com/en-us/magazine/ff686706.aspx
for MOSS:
http://blah.winsmarts.com/2007-12-SharePoint_and_SQL_Server_Reporting_Services_-_Installation_and_Setup.aspx
0
 
LVL 17

Assisted Solution

by:GreatGerm
GreatGerm earned 166 total points
ID: 34174547
With the environment that you have you'll be going down the road zephyr said.  There really isn't much oob support for something like this.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question