To use ReportViewer control remote mode
to display reports deployed to SQL reporting server, you will need to
sign up with SQL Reporting service from your hosting control panel, and
have your reports deployed to the report server.
You may also want to know "How to use SQL Reporting Service web service to generate report in specific file format"
Summary to write your report viewer:
1. Using Visual Studio drag the ReportViewer control to the form
2. create a class that implements the Microsoft.Reporting.WebForms.IReportServerCredentials class.
3. override the NetworkCredentials property of the new class, you can put your login information here
4. initiate an object from the new class and assign to your ReportViewer.ServerReport.ReportServerCredentials property.
Example:
http://webho_demo.mysite4now.com/reportviewer/default.aspx
Source code:
http://webho_demo.mysite4now.com/reportviewer/reportviewer.zip
MSDN reference:
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
Known issue:
1. If you see asp.net session exception, try to set the reportviewer control Async property to False.