Hi, i'v a problem with crystal reports, - it is not funy any more - i should make a shedule, like in school.
the shedule-table should show always the all period -for example 7 days/weeks. when the retriewed date is 07-07-2007 - the all week should be shown, when appers futher 14-07-2007, two weeks will be shown....
-even when the data, retriewed from database, doesn't contain all those days, but only those, in them happends something.
i'v used a crosstable - columns are the dates (07-07-2007) and rows are hours - (start: 8:00 -end: 9:30)-and it looks now somehow so(unfortunately it's not enough):
day start time end time 07-07-2007
---+----------+--------+-------------+
Mo 8:00 9:30 "some event"
.......
.......
for retriewed data: start time=8:00; end time=9:00; date="07-07-2007"; event name="some event"
the goal is:
day start time end time 02-07-2007 07-07-2007 09-07-2007
---+----------+--------+-------------+ ............+-------------+-------------+....
Mo 8:00 9:30 "some event"
........
........
It is possible? and when yes - how? (unluckily, i'm not allowed to change/make in the database anything..... )
thanks to anyone, who knows...