Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report Design Question Post Reply Post New Topic
Author Message
jdm12
Newbie
Newbie


Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 2
Quote jdm12 Replybullet Topic: Report Design Question
     Posted: 13 May 2008 at 9:30am
I need some direction on how to design this report. I am trying to create a report for our call center managers that will show various call volume statistics broken down by hour, totaled by hour, and give a grand total as well.
 
In this particular instance the canned reports won't work because it breaks things down into 15 minute intervals or runs it for the whole day. Both of these reports give grand totals but they are not broken down by hour.
 
Connecting to the data source and getting the first hour of the day to run and report correctly is not a problem. However, since I will be using the exact same fields for different time frames is where I am getting stumped. Will I have to create a subreport for each individual hour of the day to accomplish this?
 
Thanks In Advance
 
 
J
IP IP Logged
tpc2884
Newbie
Newbie
Avatar

Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 6
Quote tpc2884 Replybullet Posted: 13 May 2008 at 9:58am

I am new to crystal reports and i need to know what table or procedure my report is link to

IP IP Logged
tpc2884
Newbie
Newbie
Avatar

Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 6
Quote tpc2884 Replybullet Posted: 13 May 2008 at 10:10am
do any one know how to find out what table a report is link to
 
thanks
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 13 May 2008 at 10:10am
Originally posted by jdm12

I need some direction on how to design this report. I am trying to create a report for our call center managers that will show various call volume statistics broken down by hour, totaled by hour, and give a grand total as well.
 


Create a group based on whichever datetime value you want to go by.  In the Group Expert, click on Options.  At the bottom of the screen that comes up, you will see something like Group Records By and a drop-down box.  Change the drop-down box to "for each hour."  That should do it for you!
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 13 May 2008 at 10:12am
Originally posted by tpc2884

do any one know how to find out what table a report is link to
 
thanks


Look in the Database Expert under the Database menu.  You can also use the View SQL Query under the same menu, but it's a little more difficult to read if you don't know SQL.
IP IP Logged
tpc2884
Newbie
Newbie
Avatar

Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 6
Quote tpc2884 Replybullet Posted: 13 May 2008 at 11:40am
thank you sometimes we all need a little help.
IP IP Logged
jdm12
Newbie
Newbie


Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 2
Quote jdm12 Replybullet Posted: 13 May 2008 at 1:05pm
Originally posted by Lugh

Originally posted by jdm12

I need some direction on how to design this report. I am trying to create a report for our call center managers that will show various call volume statistics broken down by hour, totaled by hour, and give a grand total as well.
 


Create a group based on whichever datetime value you want to go by.  In the Group Expert, click on Options.  At the bottom of the screen that comes up, you will see something like Group Records By and a drop-down box.  Change the drop-down box to "for each hour."  That should do it for you!


 
That was way to easy. Thanks!!!
 
J
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.