Results 1 to 3 of 3

Thread: [RESOLVED] Group by times in a hour span in Crystal Reports

Threaded View

  1. Nov 10th, 2005, 04:41 PM #1
    FastEddie
    FastEddie is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2005
    Posts
    259

    Resolved [RESOLVED] Group by times in a hour span in Crystal Reports

    I would like to group data like the data posted below by the hour. Basicaly what I want to end up with is between 8:00 and 9:00 there were 3 records. I can count the records easily enough but I don't know how to group by each hour. Anybody have an idea for me to get started with.

    Store # 1101

    11/01/2005 08:09:2
    11/01/2005 08:28:5
    11/01/2005 08:39:2
    11/01/2005 09:18:3
    11/01/2005 09:36:1
    11/01/2005 10:13:1
    11/01/2005 10:22:4
    11/01/2005 10:39:5
    11/01/2005 10:41:3
    11/01/2005 11:01:4
    11/01/2005 11:02:5
    11/01/2005 11:26:5
    11/01/2005 11:27:0
    11/01/2005 11:59:4
    11/01/2005 12:11:2
    11/01/2005 12:33:4





    Added [RESOLVED] to thread title and green "resolved" checkmark - Hack
    Last edited by Hack; Nov 11th, 2005 at 06:58 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width