I have to produce a report in ASP that shows all the employees names across the top and a date range down the side. I need to populate this grid with the SUM(nCount) for each employee on each day. I am getting it to grab the count for each employee but it will not populate 0's in place of the reps that donot have records for that day.
also if there are more than 1 employee with a record for that day, it will duplicate the date on the left.
basically what is am looking for is sql to grab and group the data correctly and then asp to populate a grid.
can anyone help?

table
tbl_items
__________
rep_name
nCount
date

Can you show a few sample rows of data? Probably you can use CASE to get what you want without using ASP.