create a variable based select result

thelcd

<p>Hi,</p><p> </p><p>I've got a Report Parameter that I get users to provide.</p><p>I assign this Report Parameter to a variable1 and display it in my Report Design,</p><p> </p><p>I am trying to use that variable1 as input to second query and again assign the result to another variable2.  I can only calculate the value of variable2 once the user choses variable1.</p><p> </p><p>I then get my dataset using the 2 variables.</p><p> </p><div>I am having trouble getting the 2nd variable though based on the user input.. </div><div>How can I do this?</div><div> </div>

bgbaird

<p>I think this is what your asking....</p><p> </p><p>In the report initialize method:</p><p> </p><p>variable["var1"].value = parameter["param1"].value;</p><p>variable["var2"].value = <something based on var1></p><p> </p><p>Brian</p>