Setting the datasource for a Local Report – .NET & Report Viewer

by

You need to create a ReportDataSource, and set its Value property – e.g. DataTable and IEnumerables are supported sources

As an example, and assuming that a method exists to return a DataSet, with a single DataTable matching the columns needed by your report:

DataSet ds = SomeMethodToRetrieveDataSet(); // e.g. via DataAdapter
// If your report needs parameters, they need to be set ...
ReportParameter[] parameters = new ReportParameter[...];

ReportDataSource reportDataSource = new ReportDataSource();
// Must match the DataSource in the RDLC
reportDataSource.Name = "ReportData"; 
reportDataSource.Value = ds.Tables[0];

// Add any parameters to the collection
reportViewer1.LocalReport.SetParameters(parameters); 
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.DataBind();

Note that it is often easier to just embed the RDLC into your assembly, rather than having to retain separate RDLC files. Do this by selecting the Build Action on the RDLC as Embedded Resource, and then you can set the ReportEmbeddedResource property:

reportViewer1.LocalReport.ReportEmbeddedResource = 
                         "MyOrganisation.MyAssembly.NameSpace.MyReportName.rdlc";

Note that the resource string must include the fully qualified name of the resource (including Assembly).

More Related Contents:

  1. parameter passing while generating report in ASP.NET
  2. How to make a tabbed window as in the picture using Visual C# (Studio 2010)
  3. C# – How to convert variables? (String, int, etc.) [duplicate]
  4. Can I automatically increment the file build version when using Visual Studio?
  5. Type or namespace name does not exist [closed]
  6. Configuration System Failed to Initialize
  7. How do I debug Windows services in Visual Studio?
  8. Project builds but can’t publish
  9. Writing to output window of Visual Studio
  10. I’m getting the “missing a using directive or assembly reference” and no clue what’s going wrong
  11. How do i split a String into multiple values?
  12. How do I generate a constructor from class fields using Visual Studio (and/or ReSharper)?
  13. How to debug a single thread in Visual Studio?
  14. IIS Express Immediately shutting-down running site after stopping web application
  15. How to use C# 6 with Web Site project type?
  16. visual studio 2010 conditional references
  17. Is there a format code shortcut for Visual Studio?
  18. Why does TestInitialize get fired for every test in my Visual Studio unit tests?
  19. Check if a folder exist in a directory and create them using C#
  20. Shared AssemblyInfo for uniform versioning across the solution
  21. How to programmatically include a file in my project?
  22. VS2010 – How to automatically stop compile on first compile error
  23. How can I make implementation of an interface produce an auto property instead of NotImplementedException?
  24. streamWriter rewrite the file or append to the file
  25. How do I default Visual Studio to C# projects instead of VB.NET?
  26. Read a Registry Key
  27. F5 or Start Debugging Button is Greyed Out for Winform application?
  28. WPF C# InputBox
  29. WCF, Interface return type and KnownTypes
  30. Visual Studio 2010: How to enforce build order of projects in a solution?

Leave a Comment