[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 884
  • Last Modified:

SQL Server 2005 Reporting Services. Parameter Dropdown dependent of another parameter drop down.

I am working w/ SQL Server 2005 reporting services. I can add parameters to my report and put values in two drop downs. One drop down has all the depts and the other drop down has all the employees. I want the employee drop down to depend on the dept drop down. So if the select Accounting in the dept drop down then only employees from the Accounting Dept show up in the employee dept.

In code I would create a relationship, but I don't see how to do that in SQL 2005 Reporting Services.
0
lyptus
Asked:
lyptus
1 Solution
 
lyptusAuthor Commented:
I found the answer. For anyone else who needs to do this you can find the answer here...
http://msdn2.microsoft.com/en-us/library/ms155917(SQL.90).aspx
0
 
EE_AutoDeleterCommented:
lyptus,
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

EE_AutoDeleter
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now