I've been working on SQL Server 2000 Reporting Services for the past couple of weeks.  I plan on blogging about my experience by providing tips.

Reporting Services Tip #1:

If you've created a report that you would like to deploy to a server without using Report Designer, you can upload the rdl file in Report Manager.

We've got a disconnected network where we can not connect to production except through the web application, Citrix, or by walking down to the production server room.  This means that we can not deploy the reports through Report Designer from our own desktop.  So, all that we need to do is copy our rdl and rds files to production then upload them to Reporting Services using Report Manager.  To see the upload file option, go to http://hostname/reports.

It's too bad that you can't upload multiple files using wild cards.  I thought about adding the reports by adding them to the appropriate tables in the ReportServer database, but I am just not interested in that headache right now since I've got a manageable number of reports at the moment.

You can also delete your reports in Report Manager.  Just navigate to the report, then click Show Details.  The RS toolbar changes when the details are shown.  You should now see a Delete and Move option.