1 Reply Latest reply on May 12, 2006 1:27 PM by Idit Frydman Saguey

    Default Value for Query

    Sharon Chuang

      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.
      Sharon

        • 1. Default Value for Query
          Idit Frydman Saguey

          Hi Sharon,
          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
          regards, idit