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(); } }