Bar Chart - Actuate6 formatting point values

[nillagirl]

Hi,

I am working on a summary bar chart in Actuate 6, and need to be able to display the point values on top of the bars, rounded to the nearest hundredth. Can't seem to make it work. The values still show up with only one digit to the right of the decimal point. Any suggestions would be great.

Thanks,
Nillagirl

 

[actuate123]

You have to set YLabelStyle to CharCustomLabel the the format will work. The problem is once you set the property to ChartCustomLabel, Actuate expects you to take care of everything. Finding Min & Max and ticker interval. You can over ride ComputeMinMax and calculate these values.
Muthu

 

[nillagirl]

Muthu,

Thanks for your reply. Do you have any code samples for overriding ComputeMinMax?

Nillagirl

 

[actuate123]

rptPointGraph::MaxCumulativeBalance is static Double variable defined at the top most level of the report. If you are using AcSqlDataSource you can override OnRead method of Datarow and set this value to the Max value coming from DataSource. YTickInterval, YMax are properties of Barchart control.
Let me know if this helps.

Sub ComputeMinMax( )
Super::ComputeMinMax( )
Select Case rptPointGraph::MaxCumulativeBalance
Case > 100000000
YTickInterval = 10000000
YMax = 200000000
Case 40000000 To 100000000
YTickInterval = 4000000
YMax = 100000000
Case 20000000 To 400000000
YTickInterval = 4000000
YMax = 40000000
Case 10000000 To 20000000
YTickInterval = 2000000
YMax = 20000000
Case 1000000 To 10000000
YTickInterval = 1000000
YMax = 10000000
Case 100000 To 1000000
YTickInterval = 200000
YMax = 1000000
Case 50000 To 90000
YTickInterval = 20000
YMax = 90000
Case Else
YTickInterval = 10000
YMax = 50000

End Select
' Insert your code here
End Sub