I want to create a parameter in my report that includes Client and Region. The user selects the Client from a list, but it's the Region associated with the selected Client that is used as a filter in the report.

The data for my report does not contain Client, however it does contain Region. A number of clients can belong to the same Region.

Client1 - Region1
Client2 - Region1
Client3 - Region1
Client4 - Region2

So if I select Client3 from the parameter, I want to filter my report by Region1.

Please advise. Thanking you in advance.

Hi DBlank,

Thanks for the reply. I've figure it out, I need a cascading dynamic parameter. So the first parameter is by Client, which returns the second parameter, region. Then I can use region in the report filter. This is working to a certain extent. However, it's not auto populating the Region parameter when the client is selected. You still need to select the Region from the dropdown, even though only the region for the selected client is available.