Tag Archives: SQL

Report Viewer: Create a Hyperlink to SharePoint

If you’re not aware yet, the upcoming version of SharePoint (2013) does not include a design view in SharePoint Designer anymore, which means no more no-code data view web parts. SSRS reports are a great replacement for the data view web part in many cases.  In this post, I’ll show you how to create a conditionally formatted list of tasks

Read more

Display User Data Fields for a SharePoint List

You have all of this data in SharePoint, and you have all of this information about the site users, such as their department names, phone numbers, and much more. Instead of asking for site users to fill out all of their pertinent information every time they fill out a list item, form or survey in SharePoint, wouldn’t it be nice

Read more

Easy Reporting off of SharePoint Data

Yes, it’s sometimes tedious installing and setting up SQL Server Reporting Services on your SharePoint server… but that’s not what this presentation is about.  In this presentation at the Birmingham SharePoint user group meeting, I showed that once SSRS is in place, it is easy to create reports based off of SharePoint list data.  Here is the list of demos

Read more

External Content Types – SQL Auth, NO Kerberos

It’s so easy, even I can do it!  In SharePoint 2010, Business Connectivity Services (BCS) is what used to be the BDC in SharePoint 2007.  With the BCS, you create External Content Types (ECT) that let you define a connection to a database or web service that is external to SharePoint. The actual steps of the creation of the External

Read more