passing parameter for trendline in Crystal

[TheShookster]

Hi there,
I am using Crystal 10. In the report I have trendline.
I will use this reports in few variations. Is there any way to a pass a parameter with the type of trendline(linear, logarithmic etc.)?
If no, is there anyway to do it in excel 2002?
thanks

theShookster

 

[rosemaryl]

Dear TheShookster,

While you cannot directly pass a parameter to a chart to display the trendline, what you can do is create a parameter that prompts the user for what type they want and then layer the charts on top of each other and use conditionall suppression formula to only show the one they want:

Suupress Check:

{?TrendlineType} <> 'Logarithmic'
//this report is a Logarithmic style...

and so on for each chart you need to create.

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