This is a simple DNN report... probably been done a lot before, but maybe useful to someone. I use this report for my organizations who want members to have a list of e-mails, phone numbers, and addresses for all other registered members. Obviously this is most useful in a "Private" portal.

SELECT     TOP (100) PERCENT dbo.Users.LastName AS [Last Name], dbo.Users.FirstName AS [First Name], Address.PropertyValue AS Address, City.PropertyValue AS City,
                      State.PropertyValue AS State, Zip.PropertyValue AS Zip, Phone.PropertyValue AS [Phone Num], dbo.Users.Email
FROM         dbo.Users INNER JOIN
                      dbo.UserProfile AS Address ON dbo.Users.UserID = Address.UserID AND Address.PropertyDefinitionID = '26' LEFT OUTER JOIN
                      dbo.UserProfile AS City ON dbo.Users.UserID = City.UserID AND City.PropertyDefinitionID = '27' LEFT OUTER JOIN
                      dbo.UserProfile AS State ON dbo.Users.UserID = State.UserID AND State.PropertyDefinitionID = '28' LEFT OUTER JOIN
                      dbo.UserProfile AS Zip ON dbo.Users.UserID = Zip.UserID AND Zip.PropertyDefinitionID = '30' LEFT OUTER JOIN
                      dbo.UserProfile AS Phone ON dbo.Users.UserID = Phone.UserID AND Phone.PropertyDefinitionID = '31'

Robert