I have a report that creates a list of Client Jobs with two parameters... "Client" and "Job Status". Is there a way to make Job Status a dynamic parameter so that when a specific Client is selected as a parameter, a different set of Job Statuses will appear for that client (every client uses a select list of Job Status for jobs). To complicate things further I'd also like the drop-down list of Job Statuses to include '<All>'. I'm having trouble using a "Select '<All>' as JobStatus union' in a dataset that contains 2 related tables. Can anyone steer me in the right direction? Thanks.

Hi, You mean that when client is selected you need the job status for that particular client,if so you can use cascading parameter. It will list the job status for the corresponding client.When you change the client ,it will so the job status for the corresponding client. Cascading parameter can be done by , -> use the client parameter as a where clause in the jobstatus dataset. or in the filter of the dataset. Thanks Esmari

You'll need to create these parameters "Client" and "Job Status" as cascading parameters. Modify query of "Job Status" parameter (could be a hidden dataset) and pass "Client" parameter in where clause. ex : select "Job Status" from Table where Client =@Client if you are using MDX then try to use hierarchies and pass "Client" parameter to slice cube.

Thanks Sonia, But what about having a <All> option for the Job Status.. do you know how I achieve that?

Sounds like you want a cascading parameter. That way your job status dataset will be driven by the client dataset. http://msdn.microsoft.com/en-us/library/aa337169%28v=sql.100%29.aspx Robert Attaway The SQLMDX Dude sqlmdxdude@gmail.com