Solved

X Axis Labels

Posted on 2004-03-30
3
591 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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