You can look for the prior operation if you create a variable which is equal
to the operation sequence then subtract 10 from it. Use this variable in a
join back to the JobOpr table creating an alias name for the table like
JobOpr2. The negative's are you miss added operations (025) so you will need
another report to pick these up, also you can not remove holidays from the
shop load. The positives are you can include priority dispatch information
on the shop load report, relieve work done on operations with your own
formula, create messages on the report like, "Job has started.", "Job setup
time is over estimated.", etc...
I also do a version linking to JobMtl, I have one material item (wire which
we make fasteners out of) and you are right, you need to have that material
linked to the job sequence number it is used on and include this in the
table join otherwise you will get a very slow report. We should shoot the
developer who designed the Production Calendar (ProdCal) by putting an array
in one of the tables fields, it is impossible to link to with report
builder. You would think that we learned a lesson from doing this to the
salesrep field in order entry. By the way if I could link to the production
calendar (ProdCal) I would then subtract out holidays reducing the weekly
buckets total available hours for Thanksgiving, Christmas, etc...
Merry Christmas
Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
-----Original Message-----
From: Malcolm Spann [mailto:
Malcolm@...]
Sent: Monday, September 18, 2000 06:45 PM
To:
vantage@egroups.com
Subject: [Vantage] Report Builder Question
The boss wants me to create a report simular to the Shop Load
Report, but to also include showing if the material has been
received or not. They do not want to use the Priority Dispatch
Report <sigh>.
I've set the JobOper as the primary table, and have set the
WCCode as the primary sort (and group), and the LoadDate as the
secondary sort. Filtering out the completed jobs and completed
operations (and all workcenters not applicable) gives me something
close to the initial data as deplicted in the Shop Load Report (give
or take some formating). But, determining if the material is here is
proving to be more difficult.
One option would to 'always' have, say, Operation #10 as 'Receive
Material'. As I step through the open jobs and open operations,
how can I 'look back' into a different operation #?
Another option would be to "assume" that if the prior opp had been
completed, the material is here. How can I determine the number of
the prior operation? I can't assume that it's the current opp number
minus 10, it may have been added to the job after the fact, such as
opp #25. Even if I could determine the prior op #, I'm still stuck
'looking back'.
In a programing language, it would look 'something' like:
If ((JobNum = JobNum()) and (OprSeq = 10) and (OpComplete =
.T.) then .......
I don't see that capability in Report Builder. I can analize the
"curent" record, but I can't go look at another specific record, and
still keep my place in the sort.
I really don't want to do another Group on the Job Number,
memorizing the status of Op #10, but only printing the first non-
complete record (and somehow skipping the remaining records,
*especially* any of the remaining records need to be displayed
later). Yech ....
Any help?
Thanks in advance !!
===============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
(925) 606-6505 FAX
Malcolm@...
===============================================