public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
cr_DataEntryTracker rpt = new cr_DataEntryTracker();
rpt.Site = this.Site;
return(rpt);
}
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;
}
