So I am trying to create a simple scatter plot/regression graph, and for some reason the regression line does not display after I right click on the series, go to "Trendlines", and add a regression line.

I Googled the problem, and it seems that Crystal can only handle regression lines in bar/line charts (WTF?!). Anyways, I created a line graph and formatted it so the lines are hidden and the data points show (so now the scaling is all messed up since every point is equidistant). I can get the regression lines to show, but when I select to display the formula for the line, it is displaying a slope of "0.0". My line is not horizontal, I am just dealing with percentages, so it is most likely a rounding issue.

Is there a way to change the rounding in the display formulas for regression lines? I am also peeved that I can't display a formula when I have more than 1 line active on the sheet (i.e linear regression and logarithmic regression) as it overlays 1 formula on top of the other!!! Is it something I am doing wrong, or is it an issue with crystal?

I have Crystal Reports XI Release 2.

Thanks.

Edited by krisgarcia1414 - 14 Sep 2012 at 5:30am

I appreciate the response!

We were thinking of upgrading crystal to the 2011 version, are there any issues with the upgrade process that you know of? I'm worried the current reports we have could get ruined in the process... I've seen weird things happen with Crystal :/

If we decide NOT to upgrade, would you happen to have a link to any information on using XML tags in Crystal formulas?

Thanks again.