Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

Sharepoint Web Part - SQL

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
mattpayne59
Asked:
mattpayne59
3 Solutions
 
zephyr_hex (Megan)DeveloperCommented:
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
 
zabiullahCommented:
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
 
GreatGermCommented:
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now