Times on Y axis of a chart

[Belpheghor]

I have a formula @Time_Active = TimeValue ({View_Reporting_Routes_Day.AvgOfRoutes_Time_Active})
and I want to see it on Y Axis. X axis is a datetime and displays correctly in my chart. Also when I put @Time_Active in the detail section values are shown correctly in format HH:MM

When I go to the Chart expert/Data, In the Show values box I add the field @Time_Active to it Crystal Reports 8.5 forces me to do a Count on this value. The checkbox "don't summarize values" is shaded and cannot be changed.

Is there a way to have the times in format HH:MM on the Y axis of my chart?

The field ({View_Reporting_Routes_Day.AvgOfRoutes_Time_Active})
is from an Access db and is a Date/Time field.

I would appreciate some tips if you have any idea how to solve this problem.

 

[lbass]

The issue is that your field is reading as a time, not as a quantity of time. What is the datatype of{View_Reporting_Routes_Day.AvgOfRoutes_Time_Active}? You will need to convert it to minutes, probably, in order to chart.

-LB