public ActionResult GenerateReport9()
        {
            DB50Entities db = new DB50Entities();

            var            c = db.Report9();
            CrystalReport9 r = new CrystalReport9();

            r.Load();

            Stream s = r.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

            return(File(s, "application/pdf"));
        }
        /// <summary>
        /// Download PDF of all employees loan status
        /// </summary>
        /// <returns></returns>
        public ActionResult Export9()
        {
            List <EmployeeLoan> allCustomer = new List <EmployeeLoan>();

            allCustomer = db.EmployeeLoans.ToList();


            CrystalReport9 rd = new CrystalReport9();

            rd.Load(Path.Combine(Server.MapPath("~/CrystalReports"), "ReportCustomer.rpt"));

            rd.SetDataSource(allCustomer);

            Response.Buffer = false;
            Response.ClearContent();
            Response.ClearHeaders();


            Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

            stream.Seek(0, SeekOrigin.Begin);
            return(File(stream, "application/pdf", "EmployeeloanList.pdf"));
        }