Trouble Using Group By Statement With Query

Hi,

I am having trouble getting my query right. i am using a stored procedure to retrieve this data and bind it to my grid view.

Problem: I can't associate a field with a column that i am returning with my record set.

Details: I have query that i want to return 9 columns (UserName, Pre-Approved, Processing, Underwriting, Conditioned, Approved, Docs Out, Docs Back, Conditions Met). The username column lists all loan agents. I want the other 8 columns to list the name of the borrower (crestline..borrower.lastname)  that is associate with that loan agent and that loan state.  Each time a record is found where there is a valid loan agent (UserName) that meets the 'where' conditions, there will be a borrower. the 'LoanKey' field is a primary key that lets me get the borrower name from the borrower table. I dont know how to construct my query such that those borrower names get associated with their respective column header.

if the query works, my Gridview should look like this ('Name' refers to the borrower name)

UserName | Pre-Approved | Processing | UnderWriting | Conditioned | Approved | Docs Out | Docs Back | Conditions Met 

Bob           |                     |                  |                     |    Name      |                |               |                   |

Bob           |                     |      Name   |                     |                   |                |               |                   |      

Bob           |                     |                  |                     |                   |                |               |      Name    |        

Steve         |                     |                  |      Name      |                   |                |               |                   | 

Steve         |                     |                  |                     |                   |                |    Name  |                   |

 

Here is my sql call: 

SELECT cfcdb..users.username, crestline..borrower.lastname
,CASE WHEN crestline..loansp.LoanStatus='Pre-Approved' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Pre-Approved'
,CASE WHEN crestline..loansp.LoanStatus='Processing' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Processing'
,CASE WHEN crestline..loansp.LoanStatus='Underwriting' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Underwriting'
,CASE WHEN crestline..loansp.LoanStatus='Conditioned' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Conditioned'
,CASE WHEN crestline..loansp.LoanStatus='Approved' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Approved'
,CASE WHEN crestline..loansp.LoanStatus='Docs Out' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Docs Out'
,CASE WHEN crestline..loansp.LoanStatus='Docs Back' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Docs Back'
,CASE WHEN crestline..loansp.LoanStatus='Conditions Met' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Conditions Met'
FROM cfcdb..users
inner join (crestline..loansp
inner join crestline..borrower
on crestline..loansp.loankey = crestline..borrower.loankey)
on crestline..loansp.fstnamelo=cfcdb..users.firstname AND crestline..loansp.lstnamelo=cfcdb..users.lastname
inner join cfcdb..users_roles
on cfcdb..users.username = cfcdb..users_roles.username
where cfcdb..users.active = 1
AND cfcdb..users_roles.groupid = 'agent'
AND crestline..loansp.enloanstat <> 'Closed'
AND crestline..loansp.enloanstat <> 'Cancelled'
AND crestline..loansp.enloanstat <> 'Declined'
AND crestline..loansp.enloanstat <> 'On Hold'
order by cfcdb..users.username asc