6 Replies Latest reply: Jan 14, 2014 1:26 PM by whiteline _ RSS

    How to update query based upon user's selection in inputbox?

      Hi experts,

                I used this post to to update the query based upon user's selection (or entry) in Inputbox, This is what I did.

      1. Create a variable vSelectedValue in Settings-Variable overview with a value 2013.

      2. In Inputbox property - chose vSelectedValue as ONLY displayed variables.

      3. In SQL I used WHERE year(a.DischargeDTS)='$(vSelectedValue)'

       

      However, when I selected (or enter) different values (2011,2012). The data is not updated. I do not what I have missed.

       

      Thanks

       

      Longmatch