Using Parameters in SQL Query
Our sample projects and report templates can help you learn the basics of working with our products.SQL query parameters can be substituted with real values at run time. This example replaces a parameter value just before the data is fetched.
Supplying values. Create or resolve the input parameter, assign its value before rendering, and pass the prepared report to the viewer or export routine.
In the
Supplying values. Create or resolve the input parameter, assign its value before rendering, and pass the prepared report to the viewer or export routine.
@Component({
selector: "using-parameters-in-sql-query",
imports: [Viewer],
template: `<sti-viewer [report]="report"></sti-viewer>`
})
export class UsingParametersInSqlQuery {
report: Stimulsoft.Report.StiReport;
constructor() {
Stimulsoft.StiOptions.WebServer.url = "http://localhost:9615/";
this.report = new Stimulsoft.Report.StiReport();
this.report.loadFile("Reports/SimpleListSQL.mrt");
this.report.onBeginProcessData = function (args) {
// You can change the SQL query parameters with the required values
// For example: SELECT * FROM @Parameter1 WHERE Id = @Parameter2 AND Date > @Parameter3
if (args.dataSource === 'customers') {
args.parameters[0].value = 'Germany';
}
}
}
}In the
onBeginProcessData event the query parameters are exposed through args.parameters; assigning value for the matching data source injects the run-time value into the SQL command.