(SQL Server 2005)
I have dimOrganization and dimInsideRep. The report in question has several parameters, two of which are @Division (from dimOrganization) and @SalesRep (from dimInsideRep). I would like to use @Division selected to limit the parameter list for
@SalesRep to reps from the chosen division.