To use SQL Reporting Service web service
to generate report in specific file format, you will need to sign up
with SQL Reporting service from your hosting control panel, and have
your reports deployed to the report server.
The supported file formats are XML, CSV, IMAGE, PDF, HTML, MHTML, EXCEL.
You may also want to know "How to Display Reporting Service Reports with asp.net 2.0 reportviewer control"
Summary to write your report viewer:
1. from vs.net add web reference to http://sqlreport01.mysite4now.com/reportserver/ReportExecution2005.asmx
2. create an object from the ReportExecutionService class
3. initiate parameters as sample code shows
4. call the LoadReport method and follow by Render method
5. output byte stream returned from Render method to browser.
Example:
http://webho_demo.mysite4now.com/reportviewer2/default.aspx
Source code:
http://webho_demo.mysite4now.com/reportviewer2/reportviewer2.zip
MSDN reference:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Known issue:
1. Try to key your data set small, or it will take a long time to load the report