Hi,

Im getting Crazy here. Im trying to drag information about User, Role And UserProfile on one specific user.

This is the out put i want:

RoleName ExpireDate PropertyValue PropertyValue

My problem is, i cant get two different PropertyValues or atleast not without getting two rows. This is an exampel of my SQL script:

SELECT Roles.RoleName as Subscription,  UserRoles.ExpiryDate as Expire, UserProfile.PropertyValue as Server, UserProfile.PropertyValue as Administration FROM Users
  INNER JOIN UserRoles on UserRoles.UserId = Users.UserId
  INNER JOIN Roles on UserRoles.RoleId = Roles.RoleId
  INNER JOIN UserProfile on UserProfile.UserID = Users.UserId

 WHERE  Roles.PortalId = [DNN:PortalId]
  AND    (EffectiveDate <= getdate() or EffectiveDate is null)  
  AND (Roles.RoleName like '%MyRole%')
  AND Users.UserId = [DNN:UserId]
  AND UserProfile.PropertyDefinitionID IN (SELECT UserProfile.PropertyDefinitionID FROM UserProfile WHERE UserProfile.PropertyDefinitionID=40 or UserProfile.PropertyDefinitionID=39)
 
  As you might see it is the PropertyValues from PropertyDefinitionsID 39 and 40 i need.

Now what do i do wrong here?!?

Ty m8, this work perfect.

The reson for [ ] was because i ws using the SQLView for DNN, but with the new Report, ill switch back.

Anoring oart is i missed your answer back in november, but ty anyway