How to change the axis unit values

[cecilcheah]

Hi there:

I am new in CR

I have done a graph in CR with the y-axis as time axis. The problem is it is showing the values in minutes (from database) and not hours (from CR formula).

So, is there a way to change the values in the y-axis from eg 480 to 08:00?

TIA

Cecil

 

[kenhamady]

Did you write the formula for hours?
Did you use it in your chart?
Post the formula here. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[cecilcheah]

I write the formula in the table element, then convert it to chart.

First i have make 2 groups, one is per week, and one is per room. I need to know say every week, when is the time (min, max and avg) any person enters the room to start work.

CTime (Minimum ({ANAE1OP.ERSTER_ANAESTART}, {ANAE1OP.EO_OPERATIONSSAAL})/1440)

This is for min, same for avg and max.

Then i use group options in chart wizard to show this in graphic. But the y-axis remains in numerical value and not the CTime i have used.

Any idea?

Cecil

 

[kenhamady]

What are the settings on the data tab?
Advanced/Detail or Group?
What are the other settings?
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)