Solved

X Axis Labels

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

717 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