sql server reporting services: HELP! How get user NT login -- sql server reporting services

HELP! How get user NT login

StephyB
10/13/2005 10:08:51 AM

sql server reporting services:

Hi,

I want to retrieve reports that use the Windwos authentication to filter
data linked to the user (e.g.: only sales for a specific user)

I tried to use a parameter which uses the property
system.security.principal.WindowsIdentity.GetCurrent.name,
It works fine when I run it from the designer, but when I deploy the report
on the ReportManager, I go an error:

Error during processing of 'login' report parameter.
(rsReportParameterProcessingError)

Any idea about this problem, or how to get the login by using another way?

Thanks,
Stéphanie

Re: HELP! How get user NT login

Kaisa M. Lindahl
10/13/2005 3:23:16 PM

You can use the built in RS parameter User!UserID.Value. This returns the
Windows login name, pre-Windows 2000 style.

If you need to strip of the domain name, I've written a post on how to do it
here
http://blogs.spipp.net/kaisa/archive/2005/04/15/255.aspx

Kaisa

[quoted text, click to view]