We have two domains and I need to be able to have a query in SSRS 2016 on domain A search to see if a user belongs to a group in domain B. Both domains can talk to each other. We cannot use a linked server or store any of domain B's info in domain A. We would be able to store the data while the user session is alive in domain A. Please help!
DomainA if User!UserID belongs to groupAdomainB grant access to reports A,B,D but not report C.
DomainA if User!UserId belongs to groupBdomainB grant access to report C but not reports A,B,D.
Thank you in advance!