I'm working on creating a method of publishing payroll information in a secure fashion for about 50 truck drivers. Our company website is running DNN 4 and our current backend software is running on MS SQL 2000. I can easily extract the data I want weekly and push it to our web server's sql database but how do I get the reporting tool to grab the payroll information for just the currently logged in user and no one else. Every driver has a driver ID in the software created by using the first for letters of their last name and the first two letter of their first name Example Mike Jones would be jonemi . We currently do not have user accounts setup for any of our drivers and could easily make their user names the same as their driverID in our back end system. I'd like to be able to select the current user and use that as a paramter in my select statment for the report.

I found Andrews prior post on this topic.  Do a search on @uname and you will get the post that shows how to do this.

Can you give us a little more info on how to use these values?  I tried:

SELECT * FROM DNN4_UserProfile
WHERE UserID = @UserID

and it did not work...