i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.
what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.
now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.
when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.
does someone knows how to do this?
View Complete Post