Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help requird in Cross Tab/Schedule Printing Type Report

Status
Not open for further replies.

asimasm

Programmer
Nov 27, 2000
62
AU
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]

 
Version has gantt charts, It may be worth you having a look at this ?

HTH Gary Parker
Systems Support Analyst
 
which version is it. Any other solution apart from Gant Charts..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top