I have a crosstab query: Column headings are Dates ; Row headings display job Titles and WorkDays. Values for each job are Hours/Day which fall under a particular "Start Date".
The numeric field "WorkDays" for each job indicates the number of times I'd like the "Hours/Day" to replicate itself...
I'm working w/CR 9.0 based off an Oracle database.
I have 4 groups:
1. Department {WORKORDERS.DEPARTMENT}
2. Job Number {WORKORDERS.WORKORDERNUMBER}
3. Labor Date {WORKORDERLABOR.DATE}
4. Person {WORKORDERLABOR.PERFORMEDBY}
Detail section is suppressed but contains labor times for each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.