Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Chart Sort-Specified Order issues Post Reply Post New Topic
Author Message
D333
Newbie
Newbie


Joined: 14 Apr 2011
Online Status: Offline
Posts: 3
Quote D333 Replybullet Topic: Chart Sort-Specified Order issues
     Posted: 14 Apr 2011 at 3:54am

HI all,

 

Creating a report with both a cross tab and chart, whenever I sort the chart using the specified order, the data in the chart is wrong-  Any way around this? Using CR2008. 

 

To be more specific, the data is being pulled form an access query.  Want to specify the day and time of an occurrence.  When using the specified order to edit the time (originally listed in military time) to a more user friendly text, the chart will add up occurrences for different times, ie two occurrences for 10am, when really it should be one for 10am and one for 11am.

 

Help is much appreciated. 

Thanks in advance :)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Apr 2011 at 4:57am

Do you have two fields, date and time, that you are trying to use or 1 datetime field?

if 2 fields, what is the data type for the 'military time' field?
IP IP Logged
D333
Newbie
Newbie


Joined: 14 Apr 2011
Online Status: Offline
Posts: 3
Quote D333 Replybullet Posted: 14 Apr 2011 at 5:09am

Two fields-Date and Time, yet the data is the same.  Both fields when used return the same data ie 9/28/2010 11:15:00 AM.  And so to extract the information I needed, I used two functions- HOUR and WEEKDAY, which of course produce numbers for both the hour(military) and weekday. 

Again the data source is an Access Query. 

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Apr 2011 at 5:13am
if you combine them into one datetime field in a formula you can do your calulations per day per hour by changing the group option to hourly.

Edited by DBlank - 14 Apr 2011 at 5:13am
IP IP Logged
D333
Newbie
Newbie


Joined: 14 Apr 2011
Online Status: Offline
Posts: 3
Quote D333 Replybullet Posted: 14 Apr 2011 at 5:22am
I'm a newbie, mind explaining a little more?
 
Functions I used: Time: Hour([Table_Name])![Time])
                             Date:Weekday ([Table_Name])![Date]
 
Do you mean combine those functions in access? If so how?
 
Thanks so much for your responses so far! :)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Apr 2011 at 5:40am

in crystal create formula field (name it whatever) as..

table.date + table.time
 
in your CT use this formula field as your group
click on the group options and change the 'row will be printed' option to for each hour
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.