Greeting. I am in the process of creating membership reports for a DotNetNuke portal with a few thousand members. For the life of me, I can't seem to be able to add the entended profile fields to my query (attached). I want to call members by roles and display extended profile fields like address and such. The attached querry works perfectly with the caveat that it only pulls data from the default user table. Any ideas on how to modify this code? Thanks.
FOUND THE ANSWER ON THE FORUM. For others with a similar question, follows is the sample query.
Select U.Username As [Krewe Number], U.FirstName As [First Name],
R.RoleName As [Member Level], AM.Email As [E-Mail], (Select UP.PropertyValue
From UserProfile UP
Where U.UserID = UP.UserID And UP.PropertyDefinitionID = 40) As [Costume Size]
From Users U Inner Join
UserRoles UR On U.UserID = UR.UserID Inner Join
Roles R On UR.RoleID = R.RoleID Inner Join
Aspnet_users AU On U.Username = AU.UserName Inner Join
Aspnet_membership AM On AU.UserId = AM.UserId
Where R.RoleName = 'Registered Users'