hi I want to create report from multiple list in sharepoint 2010. In general Sql Server Business Intelligence,allow create report from 1 list. how i can create report from multiple list with Sql Server Business Intelligence? thanx.

Hi luckstar, In order to retrieve mutliple SharePoint lists in a report, we need to create multiple datasets in the report, and each dataset points to one SharePoint lists. Then, in the report body, please use the Lookup Functions(new in SQL Server Reporting Services 2008 R2) to combinate the datasets. For more information, please see "Lookup Functions" in the following article: http://msdn.microsoft.com/en-us/library/ms170438.aspx#Aggregates If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

hi Jin, thanx for your answer. i read this articel http://msdn.microsoft.com/en-us/library/ee240819.aspx but i cant understand where the code(LookupSet(source_expression, destination_expression, result_expression, dataset)) would be added? my senario is:i have 2 sharepoint list.for examople: list1:1- contract number 2-contract name list2 : contract date i want to create report that show 3 item above & filter report by "start date" & "End date" thet user enter it.My another problem is i have one fiels(date) and in report wizard i can create filter base on it,but i want filter base on "start date" & "end date" that user enter it. can you help me about this? I would really appreciate if you more explain about "Lookup Functions", because i'm beginner & i dont have experience in sql server business intelligence environment. Thanks a lot.