7.5. Passing Custom SQL

The report may contain data sources that are added using the Data Wizard in Designer (via “Data|Add Data Source…” menu).

Sometimes it is needed to pass custom SQL to that data source from your application. To do this, use the following code:

using FastReport.Data;
// do it after loading the report, before running it
// find the table by its alias
TableDataSource table = report1.GetDataSource("MyTable") as TableDataSource;
table.SelectCommand = "new SQL text";

Passing Own Connection String Top Page Reference to a Report Object