Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Getting data from multiple list in SSRS

  Asked By: Donavan Talley         Date: Oct 01, 2009      Category: Sharepoint      Views: 548
 

Is there any way to get the data from multiple lists or libraries and display in my report using SSRS 2005.

Tagged:              

 

1 Answer Found

 
Answer #1       Answered By: Jonathon Palmer          Answered On: Oct 01, 2009       

I don't think there is any OOB functionality to achieve this.

There is a work around solution that will require some custom code. You have 2 custom lists  say list  A and List B. Create a temporary list C which would be used for reporting services to plot the charts. When ever there are any data  add/updates on List A or List B you need to sync the data to List C using a event handlers so that you have the latest data in the List C.

 
Didn't find what you were looking for? Find more on Getting data from multiple list in SSRS Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].