K
Karin
Good afternoon,
I have a main report and two subreports that I am working with. The main
report designates the craft, crew and date of a work order entered. The
first subreport shows the actual work orders entered on that date that were
closed as no time available. I have this part working okay.
The next sub report is where I am having an issue. I have a report from a
query which takes all actual work time performed during the 30 days following
the entry date. This needs to correspond to the inital work order date from
the main report.
I am not sure if I need to do a subreport within a subreport to make this
data line up correctly or if I should be using the grouping sections from the
main report.
I am sorry if this is confusing. I have pasted below a quick a dirty of
what I am trying to do. Please let me know if you have questions.
Thanks, Karin
Electrical Dept Zone One 2/15/08
Work Orders Closed No Time Available 2-15-08
W/O 7777777 2/15/08
W/O 8888888 2/15/08
W/O 9999999 2/15/08
__________________________________
Work Orders Completed During 30 Day period of 2/15/08
W/O 787878 2/15/08 2 hrs Physical Plant Regular Maint
W/O 898989 2/16/08 4 hrs Lighting Exchange Campus Ctr
W/O 999999 3/13/08 6 hrs New Light Install Pres office
I have a main report and two subreports that I am working with. The main
report designates the craft, crew and date of a work order entered. The
first subreport shows the actual work orders entered on that date that were
closed as no time available. I have this part working okay.
The next sub report is where I am having an issue. I have a report from a
query which takes all actual work time performed during the 30 days following
the entry date. This needs to correspond to the inital work order date from
the main report.
I am not sure if I need to do a subreport within a subreport to make this
data line up correctly or if I should be using the grouping sections from the
main report.
I am sorry if this is confusing. I have pasted below a quick a dirty of
what I am trying to do. Please let me know if you have questions.
Thanks, Karin
Electrical Dept Zone One 2/15/08
Work Orders Closed No Time Available 2-15-08
W/O 7777777 2/15/08
W/O 8888888 2/15/08
W/O 9999999 2/15/08
__________________________________
Work Orders Completed During 30 Day period of 2/15/08
W/O 787878 2/15/08 2 hrs Physical Plant Regular Maint
W/O 898989 2/16/08 4 hrs Lighting Exchange Campus Ctr
W/O 999999 3/13/08 6 hrs New Light Install Pres office