hi all, i need to extract some lists from sharepoint 2010 with 2008 R2 reporting services and manipulate data. i need to join some lists to filter some data using column that are in different lists (i have to filter after have joined the lists). is there a way to manipulate in a decent way this data? i've tried with lookup, but i hope there is a better and really usefull way to do this with a join or somethings or other stuffs like those. thanks all Logan

Hi Logan, Based on your scenario, you can try the list joins or use SQL Server Intergration Service(SSIS) to read data from SharePoint lists. For the detailed information, please see the following thread which has a similar topic: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/c4d5fd69-6eb7-427a-8be1-f3b75290ff29/ Hope this helps. Regards, Mike YinMike Yin TechNet Community Support