You are visiting the High Monkey blog archive. Posts prior to 2016 may not meet accessibility standards. Please visit our current blog area at to view accessibility compliant blog posts published since January 1, 2016.

SSRS and Data Sources

Written By: Virgil Carroll
Posted: 10/25/2011

Last week I gave a webinar on SQL Server Reporting Services and data sources. In this blog I wanted to follow up on a couple of interesting points. To set this blog up, there were approximately 60 attendees. Ok, so it was not the best representation of organizations or users:

  1. I did a poll in the beginning of the session on who is interested in using the following data sources. Here are the results:

As you can clearly see, reporting off of SharePoint Lists is the biggest need. Thank goodness for R2 and Report Builder 3.0. You can report off of SharePoint Lists with Report Builder 2.0 (SQL 2008) – but you have to write CAML.

It was very interesting to me that no one was interested in Azure. There are a couple of compelling cases in which to use Azure but it seems that the Microsoft message is not getting out there. Again, this is a small webinar with a small cross section of folks; however, I thought we might get 1%.

The second Poll I did was about reporting off of social elements:

  • Linked In
  • Facebook
  • Twitter
  • Other

No surprise Twitter and Facebook were the top two.

The other item I wanted to mention that I covered in the webinar is:

SQL Server Reporting Services AZURE: I find this to be compelling in the right use case. Take the case of this customer I just visited last week. They are using a citrix component for folks to get to their SSRS reports worldwide. This works for them but what if they hosted those reports in the cloud. Folks would just navigate to a URL, authenticate, and run the desired reports.

Before you jump all over what I said – I clearly see the disadvantages of doing this: authentication, data has to be in the cloud (which then brings a HOST of multiple issues), cost, ect.

All that being said, I am convinced there are times when SSRS in Azure makes sense.

If you are interested, see the recording here:

Best part is that you can fast forward past all the boring parts. Enjoy!

Chad's Bio Coming Soon!

More About Virgil

Virgil Carroll is the owner and president of High Monkey – based in Minneapolis Minnesota. Virgil also wears the multiple ‘hats’ of Principle Human Solutions Architect and SharePoint Architect.

Virgil is one of those rare individuals who can dive deep into technical topics while speaking clearly to the business owners of a project and never forgetting that the end user experience has the highest priority. He calls it using both sides of his brain. Virgil is passionate about leveraging technologies ‘out of the box’ as much as possible with a focus on the strategic use of content to create websites that deliver the right content to the right audience on the right device at the right time. Virgil brings high energy, an ironic wit, and a sense of grounded perspective whenever he speaks to an audience. Virgil regularly speaks at conferences and user groups throughout the United States and occasionally in Europe.

Posted: 10/25/2011 12:00:00 AM by | with 0 comments
Filed under: