You must log in to access your account.
Username
Password
Remember Me
Public Group
What is the best way for enabling reporting when some of the data is residing in Sharepoint lists and a part of it is residing in the SQL Server database.
Hi Deepak,
The best way is to use SQL Reporting Services 2008 R2. One of the new features in it is the ability to use SharePoint Lists as data sources in reports.
There is an article about this on Technet Magazine's site: http://technet.microsoft.com/en-us/magazine/ff686706.aspx
Scroll down to the "Native List Reporting" section in the article to read about it.