Hello, I am just starting to work with Reporting Services. I see with Report Builder you can create multiple datasets for a given report. Is it possible to merge or join these data sets? Also, If that is not possible, if I created the report with BIDS is it possible to merge/join within VS.net solution. thank you, mark

What version are you on?? If its SSRS 2008 R2 you can use Lookup function For more please refer this link. http://msdn.microsoft.com/en-us/library/ee210531.aspx Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Thanks, Yes I saw Lookup functions. I am running SSRS 2008 R2 Standard x64. I can see using Lookup functions for Tabular reports with out grouping, what about for actual charts. I am looking at solutions for pulling data together from various SharePoint 2007 lists. thanks a lot for your feedback. mark

Hi mark, please mark it as ANS if it helped. Thanks....Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Sorry, i read it casually... What you mean by Actual chart?? i suppose as long as you have some common Key to join you can join any type of data.... Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi, You can use the lookup, lookupset, multilookup function in expressions. These expressions can be used in tablix as well as in charts. If you need value in a chart to be looked up in another dataset, yes you can achive this by using one of the lookup functions. Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Thanks Guarav and Bilal, What i was trying to confirm about the charts is that it is possible to use Lookups within the context of the Report Builder and the data sets such that it would be like performing a join. I will have to experiment a little more with this to see if it will satisfy all of our needs. The problem when your data is in SharePoint lists is you don't have the luxury of creating a stored procedure or view to join your data. You have to join/merge this data outside of the context of SharePoint it seems. It sounds like based on your responses that lookup, lookupset, multilookup functions are the extent of the manipulation you can do with datasets in Report Builder 3.0 or Report Designer in Visual Studio.

Hi Mark, By design, the GetListItems method from SharePoint lists web service can only return one list one time. In this case, I would suggest you using Sub report: 1. Show the first list in main report. 2. Then show the second list in a Sub Report using SubReport control. For more information, please see: How to: Add a Subreport and Parameters (Reporting Services): http://technet.microsoft.com/en-us/library/ms160348.aspx If you are using BIDS in SSRS 2008 R2, of course you could make use of Lookup() functions to pull data from multiple datasets into a single report item. Thanks, Challen Fu