Created from SQL Statement¶

Dynamic Parameters in SQL Statement Data Sources

When you use an SQL statement as a data source, DataFlex Reports Studio automatically creates parameter fields for each question mark (?) in the query. This feature provides flexibility, allowing you to dynamically adjust the query results based on specific input values.

Important Note on Parameter Changes:

It's crucial to remember that modifying the SQL statement will lead to the removal and recreation of parameter fields. This means that any previously defined default values will be lost. You'll need to re-enter these values in the DataFlex Reports Studio to ensure consistent behavior.