Create Graphical Timetable - vs2005 version of Crystal

[MarkEmerson]

Hi,

I am not overly farmiliar with crystal although as i am mainly a programmer, what i would like to do is this.

I would like to display a graphical timetable, rather than just a list of activities. All my activities are stored in a database with a start date/time, end date/time, and a week pattern (111 111 111) as well as a few other fields.

The start and end dates are used for the duration of an activity as well i.e.

10/01/2006 10:00 & 20/02/2006 11:00

This would mean a 1 hour activity running from the 10/01 to the 20/02.

Any ideas? or pointers to where i can find tutorials on diaplsying graphical info rather than just lists of data?

Thanks in advance

 

[synapsevampire]

Graphical info is a tad vague, do you mean a calendar sort of approach, or?

Here's one whitepaper on creating calendars, there are plenty more on the BO site:

http://technicalsupport.businessobj...sliceId=&dialogID=4834809&stateId=1 0 4836009

-k

 

[MarkEmerson]

I will have a look through that article,

what i mean by a graphical timetable is this (a table with

09:00 10:00 11:00 12:00
Mon [Info Goes Here]
Tue
Wed
Thur
Fri

 

[synapsevampire]

A manual crosstab might suit your needs.

Create formulas of:

if 9 in hour({table.startdate}) to hour({table.enddate}) then
1
else
0

if 10 in hour({table.startdate}) to hour({table.enddate}) then
1
else
0

etc.

Then insert a group by the date and select for each day (you can format the display to show the day of the week by right clicking it and selecting format field).

Place the fields in the details and right click each and select insert->Summary->Sum and select for the date group.

Now suppress the details and the group header.

-k

 

[IdoMillet]

See:

http://www.ml-crystal.com/articles/calendar.htm

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com