We would like to automatically pass the username as a parameter to reports. By username, I mean the username from the Windows account used to access the virtual directory containing the report (which uses Integrated Windows Authentication). Sort of like the User.Identity.Name property in ASP.NET. Is this going to be possible
Thanks
Get UserName of Windows Account for Report Parameter
Hot Topic
- Increasing the row or page size
- Best practice question
- How to reference different databases on different servers in one query
- Transient ORA-03113 error in data flow task
- Size of database seems a bit large
- About SQL Mobile Server
- Linked servers and Windows Authentication
- Returning more than one of same acct instead of sum for both
- why my "advanced SQL generation options" is unavailable?
- The process could not connect to Distributor 'Distributor-name'. 20084
SQL Server
- Report Builder - parameters
- Parameterized Query Using Wildcards in VS2005
- FMTONLY, LONG Running ?
- The task "FTP Call" cannot run ...
- Passing Variables
- Problem viewing reports in Report Builder
- Spaces in Column names
- Its very slow to exec a IS package by DTExecUI
- Packages not executing right on production server?
- Export Wizard generates errors
Get UserName of Windows Account for Report Parameter
Waleed Seada
Have you tried Globasl!UserID ...or was it User!UserID ...damn, it slipped my mind; but I guess it'll help you.
Regards
amselem
User!UserID has the fully qualified user name, i.e. MYDOMAIN\MyUserName
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)