Hi All,
I really need help on this problem:
On of My Table called Day. It's indicate:
1 = Sun
2 = Mon
3 = Sun, Mon
4 = Tue
5 = Sun, Tue
6 = Mon, Tue
7 = Sun, Mon, Tue
8 = Wed
9 = Sun, Wed
10 = Mon, Wed
11 = Sun, Mon, Wed
12 = Tue, Wed
13 = Sun, Tue, Wed
14 = Mon, Tue, Wed
15 = Sun, Mon, Tue, Wed
16 = Thu
.
.
.
32 = Fri
64 = Sat
I want to make a report that list all the days that occured. For example, I have to attend training on every:
Day Time
1 10:00
3 09:00
15 11:00
Expected output:
Day Time
Sun 10:00 -----> 1 = Sun
Sun 09:00 -----> 3 = Sun, Mon
Sun 11:00 -----> 15 = Sun, Mon, Tue, Wed
Mon 09:00 -----> 3 = Sun, Mon
Mon 11:00 -----> 15 = Sun, Mon, Tue, Wed
Tue 11:00 -----> 15 = Sun, Mon, Tue, Wed
Wed 11:00 -----> 15 = Sun, Mon, Tue, Wed
I'd try to use subreport (7 subreport per days), but it really takes time to view the output.
Please help...
Cheers