Solved

Sharepoint Web Part - SQL

Posted on 2010-11-19
3
411 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 42

Accepted Solution

by:
zephyr_hex 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Infopath people picker - shading 3 65
multidimensional array 4 27
Sharepoint KB 2 24
VBA in SharePoint 3 18
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…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now