I have been asked to produce SSRS2008 reports from SharePoint 2007 lists. I have found plenty of examples for how to use getlistitems method from the Sharepoint web services within an XML data set. However every example seems to stop short of explaining how to get to the contents of the folders that sit within a document library/list.
Examples of doing this programtically through an application use the queryOptions xml element. Is this not supported when using an XML datasource in SSRS 2008 report?
Has anybody got a working example of how to do this? Or a reason why it can't be done? Or a good example of how to do this within an SSRS report without using web services?
Examples of doing this programtically through an application use the queryOptions xml element. Is this not supported when using an XML datasource in SSRS 2008 report?
Has anybody got a working example of how to do this? Or a reason why it can't be done? Or a good example of how to do this within an SSRS report without using web services?