Report with graphical timeline

[acessn]

Hi. Using CR9.0, reporting from Microsoft SQL.

I've made a report of a shiftplan which is to be printed to paper and hung on the wall. It has the following layout.

...........Mon 06.06--Tue 07-06--Wed 08.06-- etc..
----------------------------------------------
Employee 1|..07-17...|..09-17...|..08-16...|
Employee 2|..........|..12-20...|..........|
Employee 3|..14-20...|..........|..13-20...|

What I want to do is to represent this in a graphical manner, instead of just writing out the times of day.

Let's use Monday as an example, using time of day:

..06.07.08.09.10.11.12.13.14.15.16.17.18.19.20.21.22.23
E1...XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................
E2.....................................................
E3........................XXXXXXXXXXXXXXXXXXXX.........

With this view, you instantly see that there are two employees in the store between 14:00-17:00, Employee 1 and 3. Employee two doesn't work this monday.

I'm really not sure how to solve this, so any help is greatly appreciated!

Thanks,
Regards Bjorn

 

[rosemaryl]

Dear Bjorn,

What fields are available here? Do you have a shift start time and end times or are they just stored in one field??

I am assuming that you have constructed a manual crosstab and are grouping by week and suppressing the group header and footer ... Is this correct?

As you can see, more information is required before a solution can be rendered.

Regards,

ro




Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[acessn]

Hi Rosemary.

I have the shift start-time and end-time available from seperate DateTime-fields in the view I'm reporting from.

The best solution for me would be to group as you describe.

...But I've experimented a little with using a Gantt chart, grouping by Date, getting one chart for every day, which actually displays the shifts graphically. Seems my biggest problem now is to get the correct timeline on the Gantt, so it makes more sense.

Now it looks like this on Monday: (E1, E2, E3 = employees' names)

E1XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................
E2..................................................
E3.....................XXXXXXXXXXXXXXXXXXXX.........
07

when I need it to look like this:

E1...XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.....................
E2........................................................
E3........................XXXXXXXXXXXXXXXXXXXX............
..06.07.08.09.10.11.12.13.14.15.16.17.18.19.20.21.22.23.00

where the bottom line is the hours of the day. I'd settle for using the complete 24 hours time-line, from 0-24.

If this is unclear, I can post an image of my output first thing tomorrow morning when I'm back at the office.

Thanks,
Regards Bjorn

 

[acessn]

Hi.

I've illustraded some more st this address:

http://www.intime.no/crystal/index.html

Regards, Bjorn

 

[rosemaryl]

Dear Bjorn,

Unfortunately, you can not get hours on a gantt chart. For some reason they restricted the axis to days, months, and years.... not even weeks are available.

The only option, it seems to me, would be to go to a manual crosstab or to contact the company at this link:

http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

This company is the one that wrote charting for crystal and they offer an add-on to give more complex xharting. One of the example screenshots on the page shows time as you want.

Sorry, I can't be more helpful.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[acessn]

Hi Rosemary, and thanks for your time.

I'll check out the trial version on the link you provided.

Regards,
Bjorn Kaarstein
Norway