Change SQL string from Code

dotnet add package Majorsilence.Reporting.RdlViewer

In this example a RDL viewer is created and then we assign a new SQL string to the dataset for the report's DataSet "DataSetNameInYourReport". Column names and data types must match the report definition.

using Majorsilence.Reporting.Rdl;
using Majorsilence.Reporting.RdlViewer;

// One time per app instance
RdlEngineConfig.RdlEngineConfigInit();

var rdlView = new Majorsilence.Reporting.RdlViewer.RdlViewer();
await rdlView.SetSourceFile(new Uri(@"\path\to\your\report.rdl"));

// Column names and data types must match the report definition.
var rpt = await rdlView.Report();
rpt.DataSets["DataSetNameInYourReport"].SetSource("SELECT CategoryID, CategoryName, Description FROM Categories where CategoryName = 'SeaFood'");

await rdlView.Rebuild();

See the sample project.

Find the dataset name in the designer

---

Version 4 (Legacy — .NET Framework / net48)

using fyiReporting.RDL;
using fyiReporting.RdlViewer;
using fyiReporting.Data;

fyiReporting.RdlViewer.RdlViewer rdlView = new fyiReporting.RdlViewer.RdlViewer();
rdlView.SourceFile = new Uri(@"\path\to\your\report.rdl");

// Column name and data types must match the report definition.
rdlView.Report.DataSets["DataSetNameInYourReport"].SetSource("SELECT CategoryID, CategoryName, Description FROM Categories where CategoryName = 'SeaFood'");

rdlView.Rebuild();