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