Post reply

How do I link cascading parameters

  • May 5, 2006 at 10:09 am

    #114128

    In Reporting Services I need to create a cascading parameter where I have a dataset giving me a list of Departments (intDeptID and chrDescription are the fields).  I have another dataset giving me a list of Employees (intDeptID, chrLongName as the fields).  What I would like to happen is for a user to select a department and based on the value (intDeptID), have the Employee parameter be limited to only those employees who have the same value for intDeptID.  How do I link the two?

  • May 5, 2006 at 12:10 pm

    #636342

    Nevermind, I got it.  I didn't realize that I could use the @Parameter in my dataset.  Maybe there is another way but this one works.  So if anyone else out there has this problem, here is how it works.

    Parameter @Department with a Department dataset as:

    select intDeptID, chrDesc from tblDepartement

    Parameter @Employee with an Employee dataset as:

    select intDeptID, chrLongName from tblEmployee where intDeptID = @Department

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply