sql server reporting services: I am using RS2005. I display the logged in user on reports when they are
rendered in HTML by using the User!UserID parameter. It always displays as
"DOMAIN\username" no matter how I am logged in. That is fine when I log in
as "DOMAIN\username" but when users login with the User Principal Name (UPN)
...i.e. username@domain.com...I would expect it to display the UPN. Why does
it do this? How can I change it to display the actual username that was used
to log in with?

Thanks.

I don't think you can change it in any way.
But with AD accounts, all accouts have the UPN name and the good old
"Pre-windows-2000" name. Usually, these are identical, with the UPN name as
user@mydomain.com and the Pre windows as mydomain\user. BUT with some
hosting companies, these might be different. And then you need to know the
form of both, and use the logic of the Pre windows 2000 name.

Reporting Services will treat the users the same, regardless of which type
of user name they use. But if you want to use the User!UserID.value against
other systems, you should try mapping these to the Pre Windows 2000 name. Or
do a conversion from domain\user to user@domain in some way. It's really
silly, I know... Have been banging my head against this wall with customers
running their domain at a hosting company...

Kaisa M. Lindahl


[quoted text, click to view]