protected void LoadBushenyiTrackerReport(string tracker_id) { cr_DataEntryTracker objRptMain = new cr_DataEntryTracker(); ReportDocument objSubRpt = new ReportDocument(); objSubRpt.Load(Server.MapPath("~/Bushenyi_sub_report.rpt")); //foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objSubRpt.Database.Tables) //{ // Set_Report_logons.SetTableLogin(tbCurrent); //} foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objRptMain.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } foreach (ReportDocument subreport in objRptMain.Subreports) { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in subreport.Database.Tables) { Set_Report_logons.SetTableLogin(CrTable); } } DataSet ds = DataEntryTracker._ReturnDataEntryReport("Data_entry_weekly_tracker_report", tracker_id); objSubRpt = objRptMain.OpenSubreport("Bushenyi_sub_report.rpt"); objSubRpt.SetDataSource(ds); //objRptMain.SetParameterValue("@QueryType", "weekly_tracker_report"); objRptMain.SetParameterValue("@QueryType", "Data_entry_weekly_tracker_report", objRptMain.Subreports[0].Name.ToString()); objRptMain.SetParameterValue("@Tracker_id", tracker_id, objRptMain.Subreports[0].Name.ToString()); CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None; objRptMain.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "Tracker"); CrystalReportViewer1.ReportSource = objRptMain; }