May 16, 2012 at 4:11 am
SSRS 2008 - using windows autentication
I have a confidential report which I have set up as "Credentials supplied by the user running the report" to force a login. The report then uses the USer!userid collection to display information for this user, but the problem is that the user!userid is getting the windows login id rather than the login id used when running the report. Anyone know how I can populate my parameter with the correct ID. I assume I need to get the datasource login credentials through VB report code but do not know how to do this
(the consquence of the present situation is that if employee X runs report when logged in as employee X, the correct data is displayed, but if Employee Y runs the report giving his credentials while Employee X is logged in then SSRS authentcates the user but displays the data for employee X rather than Y. and this is what I am trying to avoid by forcing a login on this report)
Thanks in advance Paul
May 18, 2012 at 2:16 am
HI All,
I managed to resolve this issue myself. As I said the USerid function picks up the windows login id rather than the login used to access the datasource. But the mdx username function picks up the login ID. So I just set up a cube dataset with a calculated member to return the Username and used this in my parameter. Works perfectly
Paul
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply