Cloud
Cloud-Dienstleistung für schnelle und effektive Analyse und Visualisierung von Daten für Ihr Business ohne eigene Applikationen zu erstellen oder zu programmieren.
Using Parameters in SQL Query
Unsere Beispiele der Projekte und Berichtsvorlagen helfen Ihnen, die Grundlagen der Arbeit mit unserer Software zu erlernen.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.
import { Viewer, Stimulsoft } from 'stimulsoft-reports-js-react/viewer';
function App() {
Stimulsoft.StiOptions.WebServer.url = 'http://localhost:9615/';
var report = new Stimulsoft.Report.StiReport();
report.loadFile('Reports/SimpleListSQL.mrt');
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';
}
};
return <Viewer report={report} />;
}
export default App;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.