October 16, 2012 at 4:09 pm
Hello Fellas,
I am trying to migrate SSRS 2008 Reports that have a SQL 2008 extract from a sharepoint site which basically have datasets with store procedures built from the extracted SQL tables. I am trying to "translate" all these store procedures from the sharepoint 2010 lists, however as we know, selecting fields (joining) from multiple lists as we would join SQL tables is not supported.
Basically I am looking at other alternatives to be able to "Join" multiple lists from the Sharepoint site. I have been looking at LINQ to Sharepoint but I am not sure how i can set that up as a datasource within SSRS.
Has anyone been able to accomplish this task? We are trying to cut the "middle man" (SQL) and directly run the reports from the sharepoint "live" data (Lists) but I am having a really hard time trying to figure out how to join multiple lists.
Any help is MUCH appreciated.
Thanks!
R.
October 17, 2012 at 7:07 am
Can you insert the lists into SQL Server temp table(s)/table variables and then do what ever joining you need?
Just asking,
Rob
October 17, 2012 at 10:19 am
I don't think this is doable in real time. We are currently utilizing SSIS packages to extract the data into SQL once a day and running the reports from those SQL tables but we are trying to cut the middle man and query the sharepoint lists directly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply