Adding Two Parameters With One Depending On The Value Of The Other

hello

sorry to distub you again

in fact i'm a beginner and i don't really see how i can do some tasks

when i display a report i want the reader to choose a client, and when he chooses a client, he can choose in the second parameter list, the missions that correspond to THIS client

so i have 3 datasets

one in which i get all my data needed
and i have a filter in where part of query




Code Snippet
where client=@client
and mission=@mission




and i filter on these 2 values

in the second dataset , i gather all the clients i have by doing this query







Code Snippet
select distinct name from client





and i have this third dataset where i gather all the missions corresponding to one client

and here i write




Code Snippet
select mission_label from client
where name=@client


the two fields are in the same time and in this third dataset i apply a filter on Parameters!client.value

but when i execute the report, the second parameter doesn't work, it gives me no choice of mission for a client, it doesn't return anything while when i execute the query in the dataset i have these values

how can i do this please?

thanks a lot in advance

and sorry or bothering with such questions