Draw Custom Line option ... changing via a parameter 1

[carlgomerski]

Hi,

I've found the "Draw Custom Line at' option in Charts however I want to programmatically pass in a value (via a parameter) rather than entering a value manually. Any ideas? I'm also calling the crystal from a VB6 app.

Also, if there's a way of formatting this line differently to the other Major gridlines that would be helpful too.

Ta!

 

[carlgomerski]

I'm also using Crystal v10

 

[kenhamady]

It has been a while but I have done this by not using the "custom line" property but by writing a formula like:

WhileReadingRecords; 95

And then plotting that formula in the chart to create the line. This works in some cases but if your other values are Bars you may have to change the Series Options for this formula from BAR to LINE. Then your app can pass the formula, or pass a parameter that feeds the formula.


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[carlgomerski]

Thanks Ken, I've pretty much done what you suggested, including the value in my data source and changing it from a bar to a line in the graphed results...thanks!