Using Sql 2005 VS 2005 to create this Report.
I created a ssrs report. In the report is a dropdown. Depending on the Windows user id, I will default something in the Dropdown box. The stored procedure that is used to create the dropdown retrieves the windows user id with no problems (on my desktop).
Once I upload the .rdl to the sql Report Server, the user id is now the generic id assigned to that report server. Once on the report server, I need to access the original Windows user id not the sql report server id.
** The users Pin# is part of the Windows User Id. I need this pin#
Can this be done? Everything I read say No.