Curve function within Crystal Reports

[bessebo]

I am computing the average shipment dollars by the day of the month for the last 3 years. What I will end up with in my stored procedure is data like this:

Day 1 - 34000
Day 2 - 27000
Day 3 - 21000
Day 4 - 15700
.
.
.
Day 30 - 78000
Day 31 - 127000

What I would like to do is pass this table of data to Crystal Reports and somehow derive a function which describes the curve. Is there a way to do this?

Regards..

 

[IdoMillet]

afaik, this is not possible in Crystal.

However, place the data in Excel and create a line chart.

Select the line in the chart. Right-click and select the options to generate a trendline (select the type of curve).

Excel gives you an option to display not only the fitted trend line but also the equation.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nagornyi]

It can be done in Crystal. Any curve is defined by calculations which are cumbersome but doable in Crystal. To answer how, the type of curve to be known - linear trend, or parabola, or what? Recently I answered similar question for Actuate repors thread848-731574, in Crystal calculations can be done easier.

 

[Dan3D]

You could also create a bar chart in CR. Select the bar series and right click to bring up Chart Options -> series options dialog. Then go to the "TrendLine" section and set the type of equation you want (mean, regression, etc...)


Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com