One HUGE problem I have run into while messing withSharePoint Servicesand Reporting Services is lack of 3.0 information.
I have been working the last 2 days on getting SSRS and WSS 3.0 both working and getting them to work together. I am now a bit closer to this with the addition of adding the Reporting Services WebParts to SharePoint then getting a list of reports. Here are the steps I followed to get it all working. (note: yours could be different)
<ol>
<li>Install SQL Server 2005 and with Reporting Services (Advanced SQL </span>Server Express)</li>
<li>Install SQL Server Toolkit (with Business Intelligence Developer Studio, just a good idea)</li>
<li>Run the Report Services Configuration Tool and set the web application to be under the SharePoint. Pay attention to <a href=”http://buddylindsey.com/2007/07/10/ssrs-configuration-report-manager-virtual-directory-has-red-x/”>this post</a> when doing this step.</li>
<li>Create a new Reporting Services Database. (<a href=”http://buddylindsey.com/2007/07/10/ssrs-configuration-database-setup/”>Look at this post</a>)</li>
<li>I found the .cab file for the Reporting Services Web Parts to add to SharePointon my machinehere: “C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint”</li>
<li>With the cab file Irun <a href=”http://www.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=995″>this command</a>using stsadm.exe from this folder “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN”</li>
<li>Once thatis complete open up SharePoint inyour browser and add the Report Explorer WebPart.</li>
<li>Click edit web part -&gt; modify shared web part on the Report Explorer web part.</li>
<li>added the following URL to “Report Manager URL” <a href=”http://localhost/Reports”>http://localhost/Reports</a></li>
<li>hit ok button.</li>
<li>See alist of available reports.</li>
</ol>
What I don’t have figured out yet is viewing these reports in the report viewer web part. I also don’t know if that is even possible. yet. So stay tuned.
