Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Report Model adding roles?

Author  Topic  loiter Starting Member 7 Posts Posted - 2011-05-16 : 14:19:54 Hello, I built a small model with 4 entities. While I can confirm that each entity has a relation to the other 3 I can only pull from one in report builder (the others disappear when I choose a column). I have made sure the model overwrites when being published and even deleted the model and republished - still the relationships are not recognized in RB. I have done extensive reading and I came across a blurb of adding roles to each entity. For the life of me I cannot find the property where you attach a role. Can anyone provide a some guidance please? thanks J