We are trying to do a report off multiple SP Lists in a single report. im having trouble finding links and info on setting up filters/parameters using SharePoint Lists, though.
In the examples i can find. It is possible to query a SharePoint List and filter the results using the <query> tags. But I cant find anything on how it really works. BOL has some examples but ive not found them very helpful.
i need to be able to do the following type queries.
Create a parameter list in SSRS with distinct values from a SP list.
Do some select col1, col2 from SP List WHERE name = @parameter
Link a subreport via a parameter (ie do a join in SQL tables, i cant see a way to join multiple lists in a single table so im just doing a subreport in a column but dont see how to link the results.)
I could do the report in about 10 mins if the data was in SQL, but we dont have BCS set up and the business has issues with doing anything that breaks the norm of sharepoint (if that makes any sense)
Hope someone can guide me to results or point me in the direction of a web page ive missed or blog that shows how to do this, I cant be the first to want to do this..
thanks for any replies.