SQL 2012 :: Create A Basic Report That Displays UserID / Username / Email / Status?

I need to create a basic report that displays the userid, username, email, status and need to update the status column to enabled when we select any particular username. And the username parameter comes from the available users from the database. How to do this?

Do I need to mention the where clause where username=@username in the query or we don't need any

Also I need to get the available distinct usernames from the database while entering the parameter username

/*DECLARE variables to use IN queries*/
DECLARE @intErrorCode INT
DECLARE @ErrorMessage VARCHAR(MAX)
DECLARE @UserID INT
SET @ErrorMessage = 'Completed.'
SELECT [userid] ,

[code].....

Basically first I need to find the userid, username, accountstatus, email for a given particular user. Then I need to update the accountstatus to enabled for that selected user.

Also I need to create auditing that from before update and after update the accountstatus.