Name: Member Roster
Original Author: airpanther [Original Thread]
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],
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'
Description (by airpanther, from thread linked above): 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.