Hi
I need to print a schedule in a format similar to Cross Tab report. But i dont require summarized fields. My data contains date values and time values and against this there exist some information fields tike name etc. Now i need to diplay this information in way that against each date and corresponding time value the string value fields get displayed. Here is how my data looks like
Date: StartTime: EndTime: StudentNames: TeacherNames:
--------------------------------------------------------
25-02-2002 08:00 AM 09:00 AM s1,s2,s3,s4,s5 T1,T2,T3,T4
25-02-2002 09:00 AM 10:00 AM s5,s6,s7 T1
25-02-2002 09:00 AM 12:00 PM s2,s3,s8 T7,T8
26-02-2002 08:00 AM 09:00 AM s1,s2,s3,s4,s5 T1,T2,T3,T4
26-02-2002 09:00 AM 10:00 AM s5,s6,s7 T1
26-02-2002 09:00 AM 12:00 PM s2,s3,s8 T7,T8
And here is how i require my output to be
Date: |08:00 |09:00 |10:00 |11:00 |12:00
--------------------------------------------------------
25-02-2002 s1,s2,s3,
s4,s5
T1,T2,T3,
T4
s5,s6,s7
T1
s2, s3, s8 T7, T8
26-02-2002
s1,s2,s3,
s4,s5
T1,T2,T3,
T4
s5,s6,s7
T1
s2, s3, s8 T7, T8
I cant exactly show the output here but u can image it of any schedule like we have in Microsoft Outlook or Lotus Notes or similar scheduling software.
I m stuck on this problem for a long time but i cant think of a solution to it. Any body has any ideas of how to do it.
Thanks
![[sadeyes] [sadeyes] [sadeyes]](/data/assets/smilies/sadeyes.gif)
I need to print a schedule in a format similar to Cross Tab report. But i dont require summarized fields. My data contains date values and time values and against this there exist some information fields tike name etc. Now i need to diplay this information in way that against each date and corresponding time value the string value fields get displayed. Here is how my data looks like
Date: StartTime: EndTime: StudentNames: TeacherNames:
--------------------------------------------------------
25-02-2002 08:00 AM 09:00 AM s1,s2,s3,s4,s5 T1,T2,T3,T4
25-02-2002 09:00 AM 10:00 AM s5,s6,s7 T1
25-02-2002 09:00 AM 12:00 PM s2,s3,s8 T7,T8
26-02-2002 08:00 AM 09:00 AM s1,s2,s3,s4,s5 T1,T2,T3,T4
26-02-2002 09:00 AM 10:00 AM s5,s6,s7 T1
26-02-2002 09:00 AM 12:00 PM s2,s3,s8 T7,T8
And here is how i require my output to be
Date: |08:00 |09:00 |10:00 |11:00 |12:00
--------------------------------------------------------
25-02-2002 s1,s2,s3,
s4,s5
T1,T2,T3,
T4
s5,s6,s7
T1
s2, s3, s8 T7, T8
26-02-2002
s1,s2,s3,
s4,s5
T1,T2,T3,
T4
s5,s6,s7
T1
s2, s3, s8 T7, T8
I cant exactly show the output here but u can image it of any schedule like we have in Microsoft Outlook or Lotus Notes or similar scheduling software.
I m stuck on this problem for a long time but i cant think of a solution to it. Any body has any ideas of how to do it.
Thanks
![[sadeyes] [sadeyes] [sadeyes]](/data/assets/smilies/sadeyes.gif)