David,

Quite an interesting twist on some things you got used to.

In fact I put this statement in all my Stored Procedures.

However I do it (at least did) because of different reason....

Don,

First, you can encode within URL the way to render report. For PDF it will look like

http://Your_Server/ReportServer?%2fYour_Reports_Folder%2fYour_Report_Name&Param=1234&rs%3aClearSession=true&rs%3aFormat=PDF&rc%3aCommand=Render

By default it renders into HTML and unless it is formatted to...

It is not supported in SQL2000 by design.

http://support.microsoft.com/?kbid=896374