Hi Friends, I want to know that can i create report with connection type MSSQLSERVER using with REport Builder ? 1. Created FBA application, this Database Server is SQLSERVER not in sharepoint. 2. Using with Report builder connection type as "Microsoft SQL SERVER" can i get the SharePoint List in Report builder Query Designer. and from there can i design the reprot? Thanks & Regards Ali.MD.Liakath ali

Hi Liakath, You can get the SharePoint List in Report builder Query Designer Please check the Link below for Description http://technet.microsoft.com/en-us/library/ff519559.aspx Let us know if you are looking for anything more Regards, PS

Hi Liakath, You can get the SharePoint List in Report builder Query Designer Please check the Link below for Description http://technet.microsoft.com/en-us/library/ff519559.aspx Let us know if you are looking for anything more Regards, PS

Hi Pritam Shetty, Thanks for your reply, I tried with Microsoft SQL Server connection Type ( Data Source=AVSDT03;Initial Catalog=WSS_Content_Campus ) In Data Set Properties window when click on Query Designer, in query desinger window i am not able see the sharepoint lists. Below link is the Query Designer screen shot https://picasaweb.google.com/mohammadliyakhatali4/28Feb2011#5578591659479680626 How can i get Lists in Query Designer? Thanks & Regards Liakath AliMD.Liakath ali

Hi Liakath, You got to pass the site URL as the connection string. Please check the link below. http://prologika.com/CS/blogs/blog/archive/2009/11/24/sharepoint-list-data-extension.aspx Regards, PS