Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

X Axis Labels

Posted on 2004-03-30
3
Medium Priority
?
598 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Screencast - Getting to Know the Pipeline

610 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