In trying to incorporate business rules into my SSRS report, I need to be
able to conditionally load drop downs based upon what the selects for other
drop downs.

Can anyone tell me how? Example:
DropDown1 = Country
DropDown2 = State/Region

How Can i leave DropDown2 empty until they select from DropDown1?

Thanks.

Hi JrMcG,

Thank you for your posting!

Based on my experience, you could do the following step to get the
Parameters related.

1. Create a dataset and add a Report Parameter named Country.

2. Create another dataset named States and use the parameter in the query
text. For example:

select State from tbl_Region where Country = @Country

3. Create a new Report Patameter named State and in the Available values,
you need to use From query, and choose the dataset States, Value filed and
Label filed use State.

Then, in the preview, you could see the Parameter State could not get the
value untill you specify the value of Country.


Please try the above steps and let me know the result. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi JrMcG,

Have you got any chance to check this issue? Please let me know if you need
any help, thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

You are looking for a "Cascading Parameter" Report; there is a good
example in the sample set for SSRS 2005.

Dennis Graham
[quoted text, click to view]