When you run the setup program for SQL Server 2000 Reporting Services, select both the Reporting Services Samples and AdventureWorks Database options.

Open the Readme.htm file located in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\ Scripts folder.

Follow the instructions for running the PublishSampleReports.rss script. The script takes an input parameter called parentFolder, which lets you explicitly specify the folder where you want to publish the reports. If a folder with that name doesn't exist, the script will create it.

Modify the App.Config file in the demo application.You might need to change the server part in the RsUrl settings from localhost to the name of the server where you installed the sample reports.You must change the folder part of the ReportPath setting from SampleReports to the name of the folder you created when you published the reports in the previous step.

SQL Server 2005

When you run the setup program for SQL Server 2005, select the Sample Databases option and the Sample Code and Applications option.

Open the Readme_ScriptSamples.htm file located in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples folder.

Follow the instructions for running the PublishSampleReports.rss script file. The script installs the sample reports in the AdventureWorks Sample Reports folder.

Modify the App.Config file in the demo application.You might need to change the server part in the RsUrl settings from localhost to the name of the server where you installed the sample reports. Change the folder part of the ReportPath setting from SampleReports to AdventureWorks Sample Reports.

From the Blogs

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More