public ActionResult NorthTowerrptExcel()
{
NorthTowerrptEntity obj;
//ReportClass rptH = new ReportClass();
ReportDocument rpt = new ReportDocument();
ArrayList al = new ArrayList();
//rptH.FileName = Server.MapPath("/Reports/Northtowercal.rpt");
//rptH.Load();
rpt.Load(Server.MapPath("~/Reports/Northtowercal.rpt"));
List<NorthTowerdaycal> ItemList = (List<NorthTowerdaycal>)Session["NTR"];
foreach (NorthTowerdaycal dr in ItemList)
{
obj = new NorthTowerrptEntity();
obj.EMPID = dr.EMPID;
obj.ENAME = dr.ENAME;
obj.SECTION = dr.SECTION;
obj.JDate = dr.JDate;
obj.Status = dr.Status;
obj.TTDay = dr.TTDay;
obj.Holiday = dr.Holiday;
obj.Present = dr.Present;
obj.Absent = dr.Absent;
obj.CL = dr.CL;
obj.SL = dr.SL;
obj.ML = dr.ML;
obj.EL = dr.EL;
al.Add(obj);
}
rpt.SetDataSource(al);
MemoryStream stream = (MemoryStream)rpt.ExportToStream(ExportFormatType.Excel);
return File(stream, "application/octet-stream", "NorthTowerSummary.xls");
}
public ActionResult NorthTowerrpt()
{
NorthTowerrptEntity obj;
//ReportClass rptH = new ReportClass();
ReportDocument rpt = new ReportDocument();
ArrayList al = new ArrayList();
//rptH.FileName = Server.MapPath("/Reports/Northtowercal.rpt");
//rptH.Load();
rpt.Load(Server.MapPath("~/Reports/Northtowercal.rpt"));
List<NorthTowerdaycal> ItemList = (List<NorthTowerdaycal>)Session["NTR"];
foreach (NorthTowerdaycal dr in ItemList)
{
obj = new NorthTowerrptEntity();
obj.EMPID = dr.EMPID;
obj.ENAME = dr.ENAME;
obj.Designation = dr.Designation;
obj.SECTION = dr.SECTION;
obj.JDate = dr.JDate;
obj.Status = dr.Status;
obj.TTDay = dr.TTDay;
obj.Holiday = dr.Holiday;
obj.Present = dr.Present;
obj.Absent = dr.Absent;
obj.CL = dr.CL;
obj.SL = dr.SL;
obj.ML = dr.ML;
obj.EL = dr.EL;
al.Add(obj);
}
rpt.SetDataSource(al);
//MemoryStream stream=rptH.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "crReport");
MemoryStream stream = (MemoryStream)rpt.ExportToStream(ExportFormatType.PortableDocFormat);
return File(stream, "application/pdf");
//return File(stream, "applicaton/vnd.ms-excel");
// return File(stream, "application/octet-stream", "mytestfile.xls");
}