Report designer

In a RD, i have 2 dataset, one of them consist of two field (id and name) by which the name will be shown as a parameter. When a user select from the combo box, how do I enable the id of the this dataset to be link up as a 'parameter' to another dataset which is a query to retrieve the result?

In another words instead of using the parameter 'name' i would like to implicitly link up the id instead of the name which is shown to the user.

Thanks.

Regards

Alu

In Report Parameters, you set the

Value Field to be ID

and the

Label Field to be Name

A bit like this

<Prompt>Select Hierarchy Group</Prompt>

<ValidValues>

<DataSetReference>

<DataSetName>H_Groups</DataSetName>

<ValueField>id</ValueField>

<LabelField>List</LabelField>

</DataSetReference>

</ValidValues>

Where id is the parameter passed to the query & List is the values displayed for the user to choose from in the Listbox

|||

thanks!

Regards

Alu

sql