public ActionResult ApplicantReport() { using (FiveStarDBEntities fse = new FiveStarDBEntities()) { var ar = fse.FiveStarApplicantInformation.ToList(); return(View(ar)); } }
public ActionResult ResidentReport() { using (FiveStarDBEntities fse = new FiveStarDBEntities()) { var rr = fse.FiveStarResidentInformation.ToList(); return(View(rr)); } }
public ActionResult ResidentReportFormat(string id) { LocalReport lr = new LocalReport(); string path = Path.Combine(Server.MapPath("~/RPTReports"), "Resident_Information_Report.rdlc"); if (System.IO.File.Exists(path)) { lr.ReportPath = path; } else { return(View("Index")); } List <FiveStarResidentInformation> fsri = new List <FiveStarResidentInformation>(); using (FiveStarDBEntities fse = new FiveStarDBEntities()) { fsri = fse.FiveStarResidentInformation.ToList(); } ReportDataSource rd = new ReportDataSource("FiveStarResidentDataSet1", fsri); lr.DataSources.Add(rd); string reportType = id; string mimeType; string encoding; string fileNameExtension; string deviceInfo = "<DeviceInfo>" + " <OutputFormat>" + id + "</OutputFormat>" + " <PageWidth>8.5in</PageWidth>" + " <PageHeight>11in</PageHeight>" + " <MarginTop>0.5in</MarginTop>" + " <MarginLeft>1in</MarginLeft>" + " <MarginRight>1in</MarginRight>" + " <MarginBottom>0.5in</MarginBottom>" + "</DeviceInfo>"; Warning[] warnings; string[] streams; byte[] renderedBytes; renderedBytes = lr.Render( reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); return(File(renderedBytes, mimeType)); }