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
Solved

Sharepoint Web Part - SQL

Posted on 2010-11-19
3
447 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
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 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