?
Solved

X Axis Labels

Posted on 2004-03-30
3
Medium Priority
?
595 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 1500 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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. …
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 …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

777 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