Tuesday, December 21, 2010

SharePoint Reporting Options

If you need to display chart controls in SharePoint, there are number of options, including, but not limited to:
a) SSRS in Native or Integrated Mode
b) Excel Services
c) Performance Point Services
d) Custom or Third Party Silverlight Controls
e) “Fusion Charts” - based on Adobe Flash
f) JavaScript Control libraries
g) SharePoint 2010 Chart Web Part, which is simple to use, but powerful. I described the same in an older post of mine:
h) Access 2007/2010 Reports connecting to data in SharePoint List

i) Using ASP.Net Chart Controls. Here is a useful blog which describes the same:

j) SharePoint: Interactive Charts using Google Visualization API v2.0
Google provides a JavaScript based charting API. However, you need to get data from data source and feed it to Google. Alexander Bautz provides an wrapper JavaScript library, which provides configuration options, reads data from SharePoint Lists and generates the graphs and charts using Google API.
I have made my hands dirty with all the above.
So what is the best option or recommended option to use? IMHO, there is no single best option. Some options require server side configuration changes or deployment. Others can be used by uploading code/JavaScript files to a SharePoint document library or modifications through SharePoint Designer. Access Reports is a thick client option, and has its thick client pros-cons and can be used if you have few users.
The data can be fetched using CAML Queries in either C# or JavaScript, using Data View Web Parts with some level of gymnastics involving XSLT and JavaScript, or SharePoint List connectors.
Each option has its pros/cons and needs to be evaluated on case by case basis.
The list is by no means all exhaustive and all inclusive. I have listed only the most common I have come across. If you have an opinion or alternative option to recommend, feel free to share your thoughts in the comments below.

1 comment:

Vinay Bhatia said...

Another option: