Gantt Chart Daily view

[FishKiller]

I am attempting to create a Gantt cart using CR9 Pro and SQL 2000static table.

I am using the report wizard and cannot seem to get this to view properly. I want a Gantt chart which covers one full day only. This day will be sub divided into 15 minute increments and will show when a job accession number has started and ended.

Accession filed = JBSTATIC.accession
Start date/time field = JBStatic.dic_START
End date/time field = JBStatic.dic_End

I am grouping by "JBStatic.dic_Start" by DAY

I cannot get the gantt chart to display the start and end times correctly does anyone have any ideas?

-FK

 

[synapsevampire]

Create a formula to Group by as:

if minute({table.field}) < 15 then
Time(Hour({table.field}),00,00)
else
if minute({table.field}) < 30 then
Time(Hour({table.field}),15,00)
else
if minute({table.field}) < 45 then
Time(Hour({table.field}),30,00)
else
if minute({table.field}) < 60 then
Time(Hour({table.field}),45,00)

-k