Is there any way to put default value into query? I used variables to complete the condition of WHERE clause at runtime, but I would like to put the the default instead of entering every time. Any help is much appreciated.
When you build the query instead of using variables you can put the actual values, how ever, when you run the query it will not prompt you with the option to change these values.
another option is to use XL reporter, where you can set up variables, and a default value. when you run the report you can select a different value then the default one