CrystalReport is blank with no data?

Question

Hi Team   I have created a crystal report, but the issue its empty there is no data. While i check from the column with the database there is a record. Please help mates, what could be the reason for this irregularity? 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);                     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();               }                            }

Laxmidhar Sahoo · Answer

Hi   Put after setdataset(data)   ReportDocument rpt =  new  ReportDocument();                 rpt.Load(Server.MapPath( "~/Reports/uYiloReporting.rpt" ));                 rpt.SetDataSource(data);       CrystalReportViewer crystalReportViewer1 =  new  CrystalReportViewer();            crystalReportViewer1.ReportSource = rpt;            crystalReportViewer1.Refresh();              this .Controls.Add(crystalReportViewer1);            crystalReportViewer1.Dock = DockStyle.Fill;     Thanks and regards

Guest User · Answer

Which line from my logic do i have to implement this change? Then once i know i will add and test it, revert back to you.

Laxmidhar Sahoo · Answer

Hi   You did not add your report to reportviewer .You can add viewer in dynamic or dragdrop. Bellow is the code for add viewer   CrystalReportViewer crystalReportViewer1 =  new  CrystalReportViewer();          crystalReportViewer1.ReportSource = rpt;          crystalReportViewer1.Refresh();            this .Controls.Add(crystalReportViewer1);          crystalReportViewer1.Dock = DockStyle.Fill;   Thanks and regards

Guest User · Answer

Ok thanks does anyone know the right assembly for this crystalreportViewer? many i have installed but cant seem to find appropriate one pls assist.