Hi there,
RS reports can be rendered in your application, through a browser (eg internet explorer), excel, HTML, pdf, tiff and csv by default, and I believe you can create custom rendering types as well. SQL Server Management Studio can be used to administrate some of the fuctionality, as can the Reporting Services "reports" website...
This link (http://msdn.microsoft.com/en-us/library/ms156312(SQL.90).aspx) might be a good place to start understanding the rendering possibilities...
Hope this helps,
Charley.
Charley Hanania
B.Sc (Computing Science), MCP, MCDBA, MCITP, MCTS, MCT