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

Guest User

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
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;
0
Guest User6y ago
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");
       }

   }
0
Laxmidhar Sahoo6y ago
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
0
Jignesh Kumar6y ago
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");
0