Hello,

You can use lookupset function of SSRS for more detail see this link

http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html