An error occurred during report processing. -RLDC reporting in ASP.NET MVC

by

Have you try like this after adding a TableAdapter? It is working perfectly for me.

public FileResult Report(string id)
{
    PersonTableAdapter ta = new PersonTableAdapter();
    PersonDataSet ds = new PersonDataSet();

    //for avoiding "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." error
    ds.Person.Clear();
    ds.EnforceConstraints = false;

    ta.Fill(ds.Person, id); //You might customize your data at this step i.e. applying a filter

    ReportDataSource rds = new ReportDataSource();
    rds.Name = "ReportingDataSet";
    rds.Value = ds.Person;

    ReportViewer rv = new Microsoft.Reporting.WebForms.ReportViewer();
    rv.ProcessingMode = ProcessingMode.Local;
    rv.LocalReport.ReportPath = Server.MapPath("~/Report/Person.rdlc");

    // Add the new report datasource to the report.
    rv.LocalReport.DataSources.Add(rds);
    rv.LocalReport.EnableHyperlinks = true;
    rv.LocalReport.Refresh();

    byte[] streamBytes = null;
    string mimeType = "";
    string encoding = "";
    string filenameExtension = "";
    string[] streamids = null;
    Warning[] warnings = null;

    streamBytes = rv.LocalReport.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);

    return File(streamBytes, mimeType, "Person" + "_" + id + ".pdf");
}

Hope this helps…

More Related Contents:

  1. Loop through enum result property
  2. How to return a file (FileContentResult) in ASP.NET WebAPI
  3. ASP.NET MVC 5 group of radio buttons
  4. Questions about using Ninject
  5. Passing data between different controller action methods
  6. Is Task.Run considered bad practice in an ASP .NET MVC Web Application?
  7. Remote Validation for LIST of MODELs
  8. Passing data to Master Page in ASP.NET MVC
  9. How to enable cross origin requests in ASP.NET MVC [duplicate]
  10. Do I need a Global.asax.cs file at all if I’m using an OWIN Startup.cs class and move all configuration there?
  11. Is it secure to store passwords in cookies?
  12. How do I display the DisplayAttribute.Description attribute value?
  13. ASP.Net MVC route to catch all *.aspx requests
  14. Visual Studio – Resx File default ‘internal’ to ‘public’
  15. ASP.NET MVC – How to show unauthorized error on login page?
  16. Project builds but can’t publish
  17. How to make Check Box List in ASP.Net MVC
  18. How do I setup multiple auth schemes in ASP.NET Core 2.0?
  19. I’m getting the “missing a using directive or assembly reference” and no clue what’s going wrong
  20. MvcSiteMap generating a Menu without messing the breadcumbs
  21. how to get mac address of client that browse web site by asp.net mvc c#
  22. The model item passed into the dictionary is of type ‘mvc.Models.ModelA’ but this dictionary requires a model item of type ‘mvc.Models.ModelB‘
  23. Get UserID of logged-in user in Asp.Net MVC 5
  24. How to pass parameters to a custom ActionFilter in ASP.NET MVC 2?
  25. Can I use ASP.NET MVC together with regular ASP.NET Web forms
  26. Login page on different domain
  27. How to create Select List for Country and States/province in MVC
  28. How to use multiple form elements in ASP.NET MVC
  29. Specify Date format in MVC5 (dd/MM/yyyy)
  30. LINQ to Entities does not recognize the method ‘System.String ToString()’ method in MVC 4

Leave a Comment