Hi all, I was wondering if there is a way to capture the current users windows login and use that to personalize as report by displaying the users name at the top...or customizing report output by using the windows login as a query or report parameter.
This is very simple with Visual Studio 2005.
If you only have SQL 2005, on the edit expression screen use Globals -> UserID.
|||Yes, it is easy to do... You can create a report parameter to capture the user id by using
=User!UserID
This will return you the credentials of the user who is trying to run the report which you can use anywhere in the report.
sql
No comments:
Post a Comment