Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: shedule in crystal reports? Post Reply Post New Topic
Author Message
Theo439
Newbie
Newbie
Avatar

Joined: 24 Jul 2007
Location: Czech Republic
Online Status: Offline
Posts: 2
Quote Theo439 Replybullet Topic: shedule in crystal reports?
    Posted: 24 Jul 2007 at 2:24am

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..... Dead)

 
thanks to anyone, who knows...Tongue
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Jul 2007 at 8:49am
If you can create a query that will pull all of the data for each day of the week as a single record, then it's possible.  However, from your examples, it doesn't look like that's going to be possible.
 
Also, if you want every date, they all need to be in the data.  In general, you can't display dates that don't exist in your data.  (If you were only displaying one week at a time, I can think I can come up with a way to do it, but not for the long timeframe you're dealing with.
 
-Dell
IP IP Logged
Theo439
Newbie
Newbie
Avatar

Joined: 24 Jul 2007
Location: Czech Republic
Online Status: Offline
Posts: 2
Quote Theo439 Replybullet Posted: 26 Jul 2007 at 12:34am
Hi, thank you for an answer, i also think, it's not possible, but because i don't have much expierience with crystal reports, i decided put a question here.
 
thank you!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.