Hi All,

My problem is in regards to linking 2 report filters together. I need to be able to select a sales rep and have only that sales Reps stores come up when filtered. Right now I have the store numbers and the sales reps listed, but it shows all, and there is no linking between the two.


Source Data (Master Data)

Str # Rep Name
1000 Joe 1
1200 Joe 1
1300 Joe 2
1400 Joe 2


When filtered

Str # (All)
Rep name (All)


If you select either you will see all the stored and all the reps, but selecting the rep, does not show what stores belong to that rep.

What I need to have happen:

Rep Name (Joe 1)
Str # 1000,1002,1003 etc


is this possible?


Thanks