spSolicitorListingReport

            CREATE PROCEDURE [dbo].[spSolicitorListingReport]
                (@FundraiserId int)
            AS
                select
                    usr.LastName,
                    usr.FirstName,
                    frt.Id TeamId,
                    frt.Name TeamName,
                    dbo.fnFundraiserIsCaptain(frs.TeamId, frs.id, frs.RootFundraiserId) Captain, 
                    dbo.fnFundRaiserSolicitorDonationCount(frs.id) Donations,    
                    frs.goal Goal,    
                    dbo.fnFundraiserSolicitorDonationTotal(frs.id) TotalRaised
                from 
                    dbo.fundraiserSolicitors frs
                    inner join dbo.fundraisers fr on fr.id = frs.rootFundraiserId
                    inner join dbo.clientusers usr on frs.ClientUsersId=usr.id 
                    left join dbo.fundraiserTeams frt on frs.teamid = frt.id
                where 
                    frs.rootFundraiserId = @FundraiserId
                    AND usr.Deleted = 0
                order by 
                    LastName, FirstName