I am using Crystal Reports XI, and having trouble with display formatting for a line graph
My Axes data is grouped using this formula:
***(NOTE - I'm Basically, looking at a whole years data, but ignoring the DATE part, and just looking at Time of Day to see how many calls came in, in the 1am time period, 2am etc)
CDATETIME(
(If Hour({case_services.call_received_time}) in 00 to 07 then cdate(2015,01,02) else cdate(2015,01,01)),ctime(totext(Hour({case_services.call_received_time})))
)
This sorts my data overnight, from 8pm-8am, in correct time order in my line graph, making 11pm, 1/1/15, and 12pm onwards 2/1/15.
BUT - now the chart displays 01/01/1900 08:00:AM instead of just 8AM
How do I make the chart display ONLY the hours, without loosing the time sort order on the overnight shift???
The only way I can currently do it, is to physically click on each copy of the graph in the preview mode, and individually change the text.
Let me know if you need more information.
Thanks
My Axes data is grouped using this formula:
***(NOTE - I'm Basically, looking at a whole years data, but ignoring the DATE part, and just looking at Time of Day to see how many calls came in, in the 1am time period, 2am etc)
CDATETIME(
(If Hour({case_services.call_received_time}) in 00 to 07 then cdate(2015,01,02) else cdate(2015,01,01)),ctime(totext(Hour({case_services.call_received_time})))
)
This sorts my data overnight, from 8pm-8am, in correct time order in my line graph, making 11pm, 1/1/15, and 12pm onwards 2/1/15.
BUT - now the chart displays 01/01/1900 08:00:AM instead of just 8AM
How do I make the chart display ONLY the hours, without loosing the time sort order on the overnight shift???
The only way I can currently do it, is to physically click on each copy of the graph in the preview mode, and individually change the text.
Let me know if you need more information.
Thanks