You can change data with checkboxes above the SQL report without adjusting the SQL code.



For this purpose, you will find four variables for free configuration in the Variables area.
Under Name you assign the name that is to be displayed above the SQL report for this variable.
With Default you assign a standard value which is preset and with Type you can determine which basis the selection option has. So for orders for orders or samples for samples or just a simple drow down list with comma separated values.



You now integrate the variable defined in this way into the SQL query with e.g._VAR0_.
Attention: If you do not integrate the variable into the query, the selection fields above the SQL report remain, but have no effect on the SQL report.

Variables for the period
To make a time period adjustable, simply integrate the following code into the SQL query at a date field:

BETWEEN
_FROMDATE_ AND _TILLDATE_



You can then run the SQL report according to your desired time periods.