Using Adapter in SSRS

Sep 1, 2009 at 1:57 PM

Dear Friends,

      We are building SSRS reports consumeing MOSS 2007 lists but lot of issues, i tried adapter option i am able to fetch data from sharepoint lists in SSIS, but i not able to figure out how to do same in SSRS. Please help me using SharePointListAdapter in SSRS to fetch data from list and build reports which can be viewed in reportviewer webpart

Thanking you

Ajay K.N

Mob: 919043578331

Sep 29, 2009 at 5:55 AM

Well, for SSRS, the upcoming SharePoint 2010 stack and future SSRS will be much tighter in integration, so the problem will go away with time.  As we do not always have time to wait, the only option in your case, i'm afraid, would be to pull the data down using the adapters to a sql table of some sort and point your SSRS reporting to that table.

Good luck!