Ahmed

It can be small problem to show all profiles fields. Because:

1) It is not the same table as users. Users is in the "users" table, properties of each user in the UserProfile table.
2) Second problem is: UserProfileTable relates to the Users table as many to one. So profile properties for each user are not in single row, but in many rows. For better understanding just run a query

SELECT * FROM UserProfileTable; 

To show just FirstName, lastName, Email, UserID and other important fields you can use view vw_Users. So it will be like: 

SELECT * FROM vw_Users;

Sergey

---

 

I see. So there is no way to display a report based on users' profile?