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

Exclude a SharePoint list or library from SharePoint Search

To exclude all the items in the document library or list  from appearing in to search results:

1.Navigate to the List
2.Go to list Settings
3.Then go to advanced settings of the list and check the option to remove from search results at the bottom. 
This will stop the search from hitting that specific list or document library.