CODEWITHSUNDEEP
sql-serversharepointreporting-servicessharepoint-2007ssrs-2008
anbuj
anbuj

Reputation: 519

How to connect MOSS 2007 list with SSRS?

I'm working with moss 2007. I need to do some SSRS reports. It seems that SSRS-Sharepoint connectivity via sharepoint services only allowed in same domain(as windows authentication is the only option allowed). I have sharepoint server running on different domain than the SSRS server domain. By the way, SSIS is not an option. Now I need to creat reports using the data on sharepoint list. I know I can do it by creating an app to retrieve and update the data to Sql Server and shedule it. But again I want to know is there any direct way. Could someone please give me some hints to start?

Upvotes: 0

Views: 79

Answers (1)

Nathan Griffiths
Nathan Griffiths

Reputation: 12756

Normally I would suggest using the Sharepoint List connection type as a data source in your report, however if the Sharepoint instance is in a different domain to the report server and there is no trust relationship between the domains to allow passing of credentials then I don't think that will work for you.

In that case I think your only option is to extract the data from the Sharepoint list by some other means (SSIS would be a good choice but you say that is not an option for you) into a location accessible from your report server.

Upvotes: 1

Related Questions