I must thank you also.  I was going to post the same question today and your answer was perfect. 

Follow up question...it seems that you can change the name of...

If y1 and y2 are a date datatype, you will need to convert them to strings.  I know Crystal allows you to put columns of different data types together into...

Right...you will still perform the link but will manipulate the data that comes back.  You can also change the column you are linking on to use the case statement so...

Would this work for what you are trying to get?:

select

case when username = 'James1' then 'CIS' when username = 'James2' then 'Astronomy' else AOofficeName end as Office,

count(ARid) as totReferrals...