Setting multi Parameters from 1 data set

rmalcolm

<p>In my report it runs a query to produce a list of values. When I select the value from this list it is essentially select the row with the matching value. I want to set more than one parameter uses the values from the same row.</p><p> </p><p>For example if the Data set returns</p><p> </p><p>ID   Surname   DateOfBirth</p><p>1 Smith   20000822</p><p>2 Jones   19800614</p><p>3 Brown   19600221</p><p>4 White 19721116</p><p> </p><p>and I select the Surname Jones. This will set 1 parameter SurnameParam, with 'Jones' but I'd like to also set another parameter DOBparam with the DateOfBirth value from the same selected row</p>