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

    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?

    table
    tbl_items
    __________
    rep_name
    nCount
    date

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    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
  •