CODEWITHSUNDEEP
t-sqlreporting-servicesreportbuilder
confusedKid
confusedKid

Reputation: 3251

Cascading Parameters in Report Builder 3 for a Many-to-Many relationship dataset

I got a request to create a cascading parameter for Projects in a dataset like this:

Project     Manager
    A          Person 1
    A          Person 2
    B          Person 1

etc...

When the user chooses a particular manager, this works fine, but the user can also choose all the managers, in which case there would be multiples of the same Project in the parameter drop down list...

I'm very new to SQL, so any help would be much appreciated!

Upvotes: 2

Views: 403

Answers (1)

dotjoe
dotjoe

Reputation: 26940

I think you're looking for a group by project or select distinct for the second query.

select project from ... where manager_id in (1,2) group by project

Upvotes: 1

Related Questions