here is some extra information regarding that
actually the .aspx file contains the report viewer, a couple of text box and dropdowns for the search criteria.
the code behind lays in a flat try-catch construct
in which the code goes like
ConnectionInfo mycon = new ConnectionInfo();
mycon.UserID = "userID";
mycon.Password = "password";
mycon.DatabaseName = "dbname";
mycon.ServerName = "servername";
//creating report document
ReportDocument rpt_doc = new ReportDocument();
string path = Server.MapPath(@"MyReport.rpt");
Response.Write("report is going to load");
rpt_doc.Load(path);
Response.Write("Report has now loaded");
//declaration and initialization of the parameters goes here
report_viewer.ParameterFieldInfo = myParams;
report_viewer.ReportSource = rpt_doc;
report_viewer.HasZoomFactorList = true;
report_viewer.DataBind();
//Bind
TableLogOnInfos tbl_log = new TableLogOnInfos();
tbl_log = report_viewer.LogOnInfo;
foreach (TableLogOnInfo mytablelogon_info in tbl_log)
{
mytablelogon_info.ConnectionInfo = mycon;
}
if (Session["report_viewer"] == null)
{
Session["report_viewer"] = rpt_doc;
}
ConnectionInfo mycon = new ConnectionInfo();
mycon.UserID = "admin";
mycon.Password = "Jester05";
mycon.DatabaseName = "repairs";
mycon.ServerName = "localhost";
//mycon.ServerName = "69.41.166.44";
//creating report document
ReportDocument rpt_doc = new ReportDocument();
string path = Server.MapPath(@"cr_most_replaced_spares.rpt");
if(File.Exists(path))
lbl_path.Text = path;
else
lbl_path.Text = path+" not exist.";
rpt_doc.Load(path);
***********************************************************
the control falls in the catch block when executing the red marked line as the "Report has now loaded" - line is not printed but previous one is printed.
and the exception message is what I told you before("Load report failed").
Please let me know if any other information I missed or not.
Thanks
Supradip