MarkEdmondson
Programmer
Good Morning,
I'm using Crystal to ODBC into a medical database. I'm currently trying to report out on surgical delays. In my data source there is a field that calculates this. The problem is it's a number in a text format.
I've been able to convert this to a time field for detail line display using:
@DELAY TIME TO NUMBER: Tonumber ({DELAY_TIME}) and then for detail display this:
CStr( int({@Delay Time To Number}/60),"#")+":"+CStr(Remainder({@Delay Time To Number},60),"0#")
and then for display in a crosstab I added:
CStr( int(CurrentFieldValue/60),"#")+":"+CStr(Remainder(CurrentFieldValue,60),"0#") to the display string.
Is there any means available to get this text-to-number data to appear in a bar or line graph with the Y-axis label in hours format?
I'm using Crystal to ODBC into a medical database. I'm currently trying to report out on surgical delays. In my data source there is a field that calculates this. The problem is it's a number in a text format.
I've been able to convert this to a time field for detail line display using:
@DELAY TIME TO NUMBER: Tonumber ({DELAY_TIME}) and then for detail display this:
CStr( int({@Delay Time To Number}/60),"#")+":"+CStr(Remainder({@Delay Time To Number},60),"0#")
and then for display in a crosstab I added:
CStr( int(CurrentFieldValue/60),"#")+":"+CStr(Remainder(CurrentFieldValue,60),"0#") to the display string.
Is there any means available to get this text-to-number data to appear in a bar or line graph with the Y-axis label in hours format?