Hi All, I want to know how SQL reporting integrates with SharePoint. I just started a new DBA job and the company is looking to have SQL reports in Sharepoint. I am not familiar with SharePoint so have a few queries. 1. The company currently uses SQL Server 2005 and SharePoint 2003. Is it possible to have SQL reports in SharePoint with these versions? If not what is incompatible or are both incompatible? 2. The company will be upgrading to SQL Server 2008 R2 and SharePoint 2010. Are these better designed for such reporting? If so what tools or configuration options do I need? Regards Paul

Hey Paul, refer these links which give you a brief idea to achieve this http://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007 http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html http://blah.winsmarts.com/2007-12-sharepoint_and_sql_server_reporting_services_-_installation_and_setup.aspx A video tutorial @ http://www.youtube.com/watch?v=W6gk9VqnGMs&feature=fvwrel hope this helps Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

Hey Paul, refer these links which give you a brief idea to achieve this http://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007 http://mosshowto.blogspot.com/2009/01/integrating-sql-server-2008-reporting.html http://blah.winsmarts.com/2007-12-sharepoint_and_sql_server_reporting_services_-_installation_and_setup.aspx A video tutorial @ http://www.youtube.com/watch?v=W6gk9VqnGMs&feature=fvwrel hope this helps Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

Cheers Pratik. I'll take a look.