Hi,

I want to write the user name and his data display by query i try to use reports module for that and i finf that i can pass parameter to it like user id @UserID

but how can i give this parameter value from text ir any thing i write this query

select Users.Username,Users.Email,ProfilePropertyDefinition.DefaultValue from Users inner join UserProfile on(Users.UserID=UserProfile.UserID) inner join ProfilePropertyDefinition on (UserProfile.PropertyDefinitionID=ProfilePropertyDefinition.PropertyDefinitionID)
where Users.UserID=@UserID

but it display the data of the first name only can anyone help me and tell me how can i give the name of the user and the reports module display his data

thanx in advance