How to create crystal report in asp.net mvc using c#?

Question

Hi Team I want to create a report, my report should be in a position on View to allow user to download it as XML format not PDF. Are there any examples around crystal report in asp.net mvc using c#? I need some help towards my application, please assist mates thanks.

Laxmidhar Sahoo · Answer

hi I am not getting your point.Bellow is code for ado.net connection DataSet ds = new DataSet(); oleAdapter.Fill(ds); ReportDocument rpt = new ReportDocument(); rpt.load(); rpt.Database.Tables[0].SetDataSource(ds.Tables[0]); this .crystalReportViewer1.ReportSource = rpt;

Guest User · Answer

Hi Team I need some help below with the object instentiation call, i dont use entity framework for my connection to .NET Object, its purely connection to my Database with model reference. How do i pass this if i want to use ConnectionManager instead that empEntities context = new EmpEntities(); public ActionResult Download_PDF() { empEntities context = new empEntities(); // This here. ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath( "~/Report" ), "Emp_Data.rpt" )); rd.SetDataSource(context.emp_table.Select(c => new { id = c.id, name = c.name }).ToList()); Response.Buffer = false ; Response.ClearContent(); Response.ClearHeaders(); rd.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; rd.PrintOptions.ApplyPageMargins( new CrystalDecisions.Shared.PageMargins(5, 5, 5, 5)); rd.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA5; Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return File(stream, "application/pdf" , "CustomerList.pdf" ); } }

Laxmidhar Sahoo · Answer

hi Go through @ Jignesh Kumar link ,Install the crystall report .Because microsoft left if before a long time. convert xml to list or data table . then set it as report datasource

Jignesh Kumar · Answer

Hi, Please use this link for reference, You just need to change couple of thing here in ActionResult return type. https://www.c-sharpcorner.com/article/use-crystal-report-in-mvc-net/ return File(stream, "application/xml" , "YourFileName.xml" );