Print Page | Close Window

Count Calls - Only Certain Times Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22851 Printed Date: 02 May 2024 at 10:31pm Topic: Count Calls - Only Certain Times Posted By: sfullergs Subject: Count Calls - Only Certain Times Date Posted: 23 Dec 2019 at 2:52am I am trying to create a report that lists call natures and counts how many calls of each nature occur between certain times (i.e. midnight-1AM, 1AM-2AM, etc) between certain dates. I have my record select squared away, so I have a good set of data. I just need to be able to count calls between certain times of the day. I know I will need a running total and what field it will need to reset on, I'm just stuck on what the evaluation formula for this RT should be. Replies: Posted By: DBlank Date Posted: 23 Dec 2019 at 8:38am First thing is if your data unduplicated? If you need a summary you should not use a RT. Since it will reset itself you won't have any summary level data. I would consider just creating a formula to get the hour value from the time or datetime...hour(field)...and using it to group on or as part of a crosstab with a distinct count of the callid field.

Print Page | Close Window