How to fill crystalreport to download data without using design?

See more:

C#5.0

CrystalReports

ASP.NET5

Hi Team

I have logic that download crystal-report, the issue is the report returns when dowloaded with no record of any data i have from the database.

What I have tried:

//GET/Download_Report

        public ActionResult Download_ExcelReport()
        {
            //var _db = new eNtsaRegistration();

            var data = (from q in db.eNtsaRegForms select new { 
            Id = q.Id,
            FirstName = q.FirstName!=null?q.FirstName:""
            
            }).ToList();

            ReportDocument rpt = new ReportDocument();
            rpt.Load(Server.MapPath("~/Reports/uYiloReporting.rpt"));
            rpt.SetDataSource(data);
           // rpt.Refresh();
           


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

            try
            {
                Stream stream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel);
                stream.Seek(0, SeekOrigin.Begin);
                return File(stream, "application/vnd.ms-excel", "eNtsaRegistrationForm.xls");
            }
            catch
            {
                throw;
                return View();
            }

           
        }