Umm I might not be understanding what you want, as you seem to have built the complex part of the SQL already, but wouldn't just adding
" Where Volunteer.PropertyValue ='True' "
to the end of your SQL do the trick?

Also add the custom phone number property to your select statement the same as you did for the volunteer property. Doesn't matter if there is data or not in the field.

So now that I got over that hurdle (Thanks again by the way) I am working on another report module with what I have learned from your help. the problem is I want it to show only the approved members. I know that you can find approved members by typing in:

(Easy Version)

SELECT 'True' as Approved

from  aspnet_Membership

(Moderate Version)

SELECT

IsApproved

FROM

dbo.aspnet_Membership

where IsApproved='true'

(Long Version)

SELECT dbo.aspnet_Membership.IsApproved 

FROM

dbo.aspnet_Membership
where dbo.aspnet_Membership.IsApproved='true'

But I cant figure out how to join one of those statements to what I currently have as:

SELECT
u.UserName,
u.FirstName,
u.LastName,
u.Email,
Numerical.PropertyValue AS Numerical,
Street.PropertyValue AS Street,
Telephone.PropertyValue As Telephone,
Committee.PropertyValue AS Committee,
Volunteer.PropertyValue as  Volunteer
FROM
dbo.udf_UserProfileField('unit') AS Numerical left OUTER JOIN dbo.vw_Users AS U on Numerical.PortalId = U.PortalId AND Numerical.UserID = U.UserId and Numerical.PropertyValue >= ' '  join
dbo.udf_UserProfileField('street') AS Street ON U.UserId = Street.UserID AND U.PortalId = Street.PortalId  and Street.PropertyValue >= ' ' join
dbo.udf_UserProfileField('Telephone') AS Telephone ON U.UserId = Telephone.UserID AND U.PortalId = Telephone.PortalId and Telephone.PropertyValue >= ' ' join
dbo.udf_UserProfileField('Committee') AS Committee ON U.UserId = Committee.UserID AND U.PortalId = Committee.PortalId  and Committee.PropertyValue >= ' ' Join
dbo.udf_UserProfileField('Volunteer') AS Volunteer on U.UserId = Volunteer.UserID AND U.PortalId = Volunteer.PortalId
 and volunteer.PropertyValue >= ' '

 

I would even be willing to scrap what I have if someone can explain to me how to make something like this work:

SELECT 'True' as Approved

from  aspnet_Membership

Select  UserName, FirstName, LastName, Email

from Users

Select Unit, Street, Telephone, Committee, Volunteer 

from UsersProfile

Basically I just need some advice on how to only show the approved members information. Thanks for any help you can give.