Home > list, reporting services, SharePoint > SQL Services Reporting Services with SharePoint List

SQL Services Reporting Services with SharePoint List


Did you ever hear of a demand from the customers that they do need a reports based on the lists in SharePoint. Yes that does seem doable…but wait I forgot to tell you that the requirement is to do it with good old SSRS (SQL Server Reporting Services).
I also had a similar requirement from a customer and did some research and here are my findings which might help someone with similar needs
You have the following options to achieve the requirement
1.      Query the SharePoint Content database directly
Pros:
·         Easy to implement
·         Get started quickly and have good handle over the data
Cons:
·         Not supported/recommended by Microsoft
·         Not a best practice
2.      Run a parallel database
Pros:
·         Have a separate database to store list data parallel.
·         Let’s you decide what and how to store
Cons:
·         Requires extra effort and coding
·         Not easy to implement for already existing data in SharePoint
3.      Use the SharePoint web services
Pros:
·         Easy and no coding required
Cons:
·         No joins /relations possible. No parameters
·         Performance might be not that great
4.      Build Custom web services
Pros:
·         Will allow you better control than OOTB web service
·         Relational databases and queries possible
Cons:
·         Requires custom coding and effort
5.      Use third party tools
Pros:
·         Easy to implement
Cons:
·         Comes at a cost

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: