I needed a way to generate a report from list items in SharePoint. In Reporting Services, there is no way to select a SP List as a data source --- unless you create an extension.
Well, I found some great code to start with here à http://www.teuntostring.net/blog/2005/09/reporting-over-sharepoint-lists-with.html
I was able to modify this code and get it to work.
Some modifications from what the web site tells you:
The configuration files you will need to edit are as follows:
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
The assembly seems to want to be in 4 locations (2 for design and 2 for runtime); I understand the 2 for design as it needs one for the IDE setup of the data source and one for the Preview (probably), but anyway once the DLL lived in these locations, life was great:
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies\
I can see this coming in handy across our MOSS 2007 projects….
No comments:
Post a Comment