Solved

X Axis Labels

Posted on 2004-03-30
3
593 Views
Last Modified: 2006-11-17
Hello Experts,

We are trying to make a chart in Crystal Reports, that will show the number of operations in our application. We have the following data as input for the report:

- Time
- Count

Time is changed every minute and count is the number of operations for this minute. We always send exactly 1440 records (24 hours x 60 minutes).

We show the graphic in a line chart but the labels on the X axis (showing the time) will appear only if we show 1 hour only and they are really a lot. We want to show only the whole hour values (so 0:00 1:00 2:00 etc.). We tried with chart->right click->Format Chart->Grid->Group Axis->Labels->Use manual number of groups to put there 60, but it does not allow to set more than 3 in this field.

Our chart data is set as following:
chart->right click->Chart Expert->Data->Layout: Advanced (the rest are grayed)->On change of Time show Count

If you need further information I will supply it immediately.

Thanks in advance.

TheAvenger
0
Comment
Question by:TheAvenger
  • 2
3 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 10713522
I would simply not display the time values on your chart and instead create manually static text lables underneath the chart for 01:00, 02:00, etc.  Since the number of records doesn't change, the "1:00" datapoint will always be at the same spot on the horizontal axis and you can get away with a static label.

Yes, this is kind of "cheating" but it's the best way I know to deal with it.  

CR9 allows you to enter up to 7 in the "manual # of groups" which is better than 3 but still not close to the 60 that you need.

0
 
LVL 20

Author Comment

by:TheAvenger
ID: 10713616
It's interesting: this is a simple function, a lot used I would say and is available in Access report designer, which is in general less powerful...
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10713764
Well, Crystal's graphing capabilities have always (IMHO) been lagging behind the standard.  They get a little better with each version, but still not where they should be.

Ideally you should be able to use one data set for "on change of" and another field (formula) for the value to show but CR simply doesn't support it...
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question