• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

X axis intervals

Hi all,

I am using Crystal Reports 10 and am using a stored procedure to return data to a line graph.  The stored procedure returns 1 record for each second for what is typically a 20 minute cycle resulting in approximately 1200 rows or so and each row is plotted on the graph.

My issue is that I would like to show the client 60 second intervals along the X axis.  When I try to plot out all 1200 seconds, the x axis looks (predictably) awful.  Another detail is each row returned by the stored procedure is used to plot 4 lines on the same graph for the exact same second (do not know if this is contributing to my troubles).

Any thoughts?

Thanks,
DP
0
porter416
Asked:
porter416
  • 3
  • 2
  • 2
1 Solution
 
ebolekCommented:
You chnage the x axis interval like this

Right click on the chart, select chart expert
2. click axes tab
3. Unclick autorange
4. Enter min number for the axis
5. Enter max number for axis
6. Click number of divisions:manual
7. Enter the division number

Regards
Emre
0
 
frodomanCommented:
Emre's suggestion will change the axis itself - is that what you want or do you want to show only every 60th data point so you're showing 20 data points instead of 1200?  

frodoman
0
 
porter416Author Commented:
Hi frodoman,

You are correct, what I want is to show all 1200 data points on the line it self but (!), to mark only 20 data points on the X axis.  Is there a way to do this?  

Any thoughts?

Emre?

Cheers,
DP
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
ebolekCommented:
You can determine the interval between the two points as I suggested. But selecting 20 of them specifically I dont know how to do that

Most probably you have to use a special chart style like XY scattered

Regards
Emre
0
 
frodomanCommented:
No DP, there is not a way to do this (using only Crystal).  When I said 20 points, I thought that you wanted only 20 data points on your line.  On the axis you can stagger the labels but I believe you can only go as high as every third label - no where near every 20th that you need.

This is possible to do, but you would need to purchase a 3rd party Crystal plugin so there would be some expense involved.  I use CR Chart because it does allow you to change the charting behavior like you need in this situation.  It might be worth a look for you: http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

Outside of a plugin the only other workaround is to suppress the axis labels completely and just create static text objects yourself and position them manually.  Of course this only works if you have 1200 data points every time - if your SP comes back with 500 data points then your labels will be way out of position.

frodoman
0
 
porter416Author Commented:
Hi Frodoman,

Thanks for the link.  

Have you tried using this with VB in ASP.Net?  It says it will work soon with CR v10, does it?

Finally, are there any other plug in's I can look at?  I don't mind (to much) spending the $499US on this if there are no alternatives but....(hey the CA$ is up $0.82US now).

Cheers,
DP

0
 
frodomanCommented:
DP,

I've used CR Chart with VB.Net (Windows App) and with CR9 (both full version and Visual Studio version).  I haven't used with a Web App but I suspect it'll work just as well.  

I haven't seen any other plug in's that specifically handle CR charting - there may be some but I haven't come across them.  I'd recommend that you download the trial version (I assume they still have that option) and give it a try -- I've been very vocal in my disapproval of Crystal's charting and for me this product is a must-have.

Good luck,

frodoman
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now