Moving Average In Crystal Reports 8? 1

[CAPiTA]

Are these chart options only available in later versions of Crystal Reports?

 

[rosemaryl]

Dear Capita,

In Crystal 8.0, create your chart. Preview the report and right click on the chart and choose chart analyzer.

Once in chart analyzer click on a series.

Right click, and choose trendlines. You will see a long list of different trendlines, including moving averages, in the list.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[SteveW99]

Thanks for that - very helpful. One more question - is there a way to separate numeric parts in a string, ie to separate '3456' from H3456/P?

 

[Madawc]

A new topic should really be a new thread. For the case you gave, Mid({string}, 2, 4) would do it.

If the format varies it would be more tricky - try using [Search] to see various solutions that have been offered. Look here; Forum 1 is the place for Crystal formulas.

Madawc Williams (East Anglia, UK)