Hai Friends, I am Ali, I need to retrive the all lists in to Report Builder and need to prepare Report and need to deploy in Sharepoint Library. 1. I Configured Reporting Services in Sharepoint Integrated mode and Credentials are in Windows Integrated Mode not in Trusted acount. 2. In Report Builder 3.0 Connection Type "Microsoft Sharepoint List" 3. Connection String 'http://<server name>/sites/<site name>' like this, when i test the connectinons getting this error (The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.) Please anybody help me to proceed next steps. Thanks, Ali. MD.Liakath ali

Hi Ali, By default, the "Credential" for a data source is "no credential". This will cause the error you mentioned. To solve the issue, please double-click the datasource we defined, go to "Creadentials" page, and check the item "Use Windows Authentication(integrated security)" . If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, Thanks, Now My string working fine. Please help me for another questions. I need to prepare the report based on the two lists. For that 1. Created DataSource and i added two Data Sets DataSet1(Coloumns) - Admission_Number, Student_Name, Date_Of_Birth, Class DataSet2(Coloumns) - Admission_Number, Uniform, Class 2. Applied Filter in two Data Sets as "Admission Number" My Concept is Based on that "Admission Number" i want to retrive the two lists data into one report. After Creating Table When i Click on Run Getting This Error ( System.Web.Services.Protocols.SoapException: The Value expression for the text box ‘Uniform’ refers to the field ‘Uniform’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case. at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings) ) Please help me Thanks, Ali MD.Liakath ali

Hi Ali, The error is expected. In SSRS, one control can only have one detailed dataset, and the other datasets must be aggregated. This means, in order to retrieve data from other datasets, we must use aggregate functions like First, Last, SUM and so on. If we are using T-SQL to retrieve data from SQL Server, we can use the UNION. However, in this case, we are using SharePoint list as data source. We are not able to merge two or more datasets if they are come from SharePoint lists. As a workaround, please use multiple tablix control in the report body in sequence. This looks like all data comes from one dataset in one tablix. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, Thanks, For giving reply jin. U said to use Multiple Tablix control in the Report body how it is? can u explain me the location of that? Thanks, Ali.MD.Liakath ali

Hi Ali, I meant that Thanks, Jin ChenJin Chen - MSFT