Appreciate your quick response. I haven't worked with sub-reports before but will give it a try. Thanks.

hm

I found the answer to my dilemna. Instead of using Set to assign values from Users table, I used SELECT. Example, instead of SET @Len = tLength,

SELECT @Len=Len(payrollUsers.usrDept)  FROM  payrollUsers...