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
porter416Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.