Integrating SSRS Reports in MOSS

Integrating SSRS Reports in MOSS

· After installing MOSS install the SharePoint 2007 Report Services Add-In exe file
· Go to central administration page you can find the configuration links for Reporting Services
· Click on the manage integration settings link then give the report server url and authentication mode and click ok.
· Click grant database access link and give the SQL server name and select default instance and click ok.
· Click Set server defaults and change the settings as you like and then click ok.
· Then create one new web application and create site collection for that
· Select collaboration portal template
· Create one report library in your site.
· Then create your report using BI Studio
· After creating your report give the following three url to deploy your report in your website create using moss
· Target Server URL : http://moss-joseph:333/Reports/
· Target Data Source Folder : http://moss-joseph:333/Reports/Data%20Connections/
· Target Report Folder : http://moss-joseph:333/Reports/Joseph%20Lib/
Here I am deploying reports in “Joseph Lib”. And deploying my Data sources in “Data Connections”
· Then deploy your reports from BI Studio. Finally Activate the data connections
· Now go to your report library and click the report and see your reports.