Error in File CrystalReport1 19460_12996_{1FAC5040-8D16-4E07-90ED-903C4DB8EA5D}.rpt:
Failed to load database information.
protected void Report()
{
DataTable dt = new DataTable();
string query = @"select a.CompanyCode,c.CompanyName,a.EmployeeCode,b.EmployeeName,a.ProcessDate,a.Shift,a.CheckIn,a.CheckOut,a.HoursWorked,a.ExtraHours from paySwipeLOG a left join payEmployeeMaster b on a.EmployeeCode=b.EmployeeCode left join admCompanyNew c on a.CompanyCode=c.CompanyCode left join payAttribute d on b.DepartmentCode=d.AttributeCode and d.AttributeID='2' where a.EmployeeCode='bs866'";
SqlDataAdapter objAdapter = new SqlDataAdapter(query, strConn);
objAdapter.Fill(dt);
objAdapter.Dispose();
if (dt.Rows.Count > 0)
{
string reportPath = "~/CrystalReport1.rpt";
ReportDocument rd = new ReportDocument();
//rd.Load(reportPath);
rd.Load(Server.MapPath("~/CrystalReport1.rpt"));
rd.SetDatabaseLogon("Eureka", "Eureka.net", "192.168.1.6",
"FaridaHRM2122");
rd.SetDataSource(dt);
CrystalReportViewer1.ReportSource = rd;
//CrystalReportViewer1.Refresh();
}
}