Datetime chart axis - bar chart

[Eddie1979]

Hello everybody

I am relatively new to Crystal Reports (using v9 for 3 weeks) and I have a problem creating some charts which I had thought would be easy.

I have a table called 'TaskHistory' which contains 2 datetime fields - StartTime and EndTime. I created a stacked bar chart showing the number of tasks over time, based on the StartTime.

The problem with my chart is that I want it to show times when there are no records, so that the time appears in either hours:
00am, 1am, 2am, 3am, ...
or days:
Monday, Tuesday, Wednesday, ...
or years:
2004, 2005, 2006, ...
etc.

If there is no value for a time, there are gaps:
00am, 2am, 3am, 7am or Monday, Wednesday, Thursday, Saturday

Can anyone please help me find a solution to this? I have searched 4 discussion forums now and the Business Objects support library and found nothing that helps. If you need anymore information, please let me know.

Many thanks,
Eddie.

 

[pelajhia]

I think you have to have this data SOMEWHERE in order for this to work. You could put it in an excel spreadsheet - a list of hours - and link to your other data.
You'll need to have a field which truncates the time to a usable amount such as 1 am rather than 1:32:32 in order for this to work.
Hope this is clear...