Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Grouping by a date and user

    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?


  2. #2
    Join Date
    Mar 2004
    Can you show a few sample rows of data? Probably you can use CASE to get what you want without using ASP.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts