Spam:Spam: Priority Dispatch Report

In workbench in the Operations pull down there is a command "resequence". If
you were to get into a boo and add an operation between 20 and 30 - manually
giving it the number of 25 in the detail screen, you can then fire off the
resequence and it will renumber 25 to be 30, and 30 and up will increment up
by ten each.

I don't honestly know if there is a global parameter somewhere set up by a
predecessor of mine to declare that the ops should default to tens...

I was thinking about a counter, or some additional rule in the if/then that
would deal with prior_seq = 0, but so far when I've played with it I end up
getting the first sequence twice in the report.


- Alexander


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
brychanwilliams
Sent: Wednesday, March 15, 2006 3:26 AM
To: vantage@yahoogroups.com
Subject: Spam:Spam:[Vantage] Re: Priority Dispatch Report


Just out of interest, how do you resequence the job oper seq number.
Do you have to do this manually?

To determine if it is a prior operation you could develop a count.
IE. if the count is zero then there is not prior operations.


--- In vantage@yahoogroups.com, "Alexander Gamble" <alexanderg@...>
wrote:
>
> Tried something that worked, based on the ideas floating around.
>
> Using report builder, but Crystal could do similar things...
haven't built it
> in Crystal yet.
>
> JobOper - main table.
>
> JobOperPrior - sub table
>
> Join on Jobnum.
>
> User defined fields - two of them.
>
> 1) Prior_seq: integer(JobOper.OprSeq) -10 this works because
we use
> multiples of ten, and always resquence after adding "in between"
operations
>
> 2) Status_current_or_prior_seq:
> IIF(JobOper.ActProdHours>0,"Current",IIF
(JobOperPrior.OpComplete,'Current',II
> F(JobOperPrior.ActProdHours>0,'Available',"Expected"))) I think
these are
> the criteria the system is using... could have it a little off.
>
> Filter - JobOperPrior.OprSeq = JobOper.Prior_Seq
>
> Haven't figured out yet what to do with the WC that is first in
the sequences
> - in other words JobOper.Prior_Seq will = 0, and will not have a
> JobOperPrior.OprSeq....
>
>
>
>
> - Alexander
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ace_Man
> Sent: Monday, March 13, 2006 11:31 AM
> To: vantage@yahoogroups.com
> Subject: Spam:[Vantage] Re: Priority Dispatch Report
>
>
> That logic do sound pretty good. I'll give it a shot. Thank you!
>
> --- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@>
> wrote:
> >
> > Hi,
> >
> > Try this, I haven't tried it but it is just my thoughts, you
will
> > need to setup variables to pass between the two reports.
> >
> > My general thoughts are so.
> >
> > 1)Create the two reports as below, if you don't use multiple
> > assemblies.
> > 2)Create the necessary parameters to pass the relevant op code
> into
> > the filter of the sub-report.
> > 3) In the sub report, create a group on Joboper.jobnum and maybe
> the
> > assembly table as well.
> > 4) In the sub report filter on the opr seq as below.
> > 5) In the sub report group footer section add the revelant
fields,
> > qty complete, op complete etc. You will see the footer contains
> the
> > last entry.
> > 6) Create the necesary formula fields to determine regions.
place
> > these in the footer
> > 7) Create the necessary variables to pass back the values of the
> > formulas back to the main report.
> > 8) In the main report suppress the sub-report section, not sure
if
> > this will work. Match up the variables to formulas.
> >
> >
> > By the way, if you are interested, corvu has this all built in.
> >
> > I hope this helps.
> >
> >
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Ace_Man" <ace_man@> wrote:
> > >
> > > Well, That didn't work. It just gave me repeated data where
each
> > > job's opseq are multiplied by how many sequence from the
JobOper
> > to
> > > the JobOper2 table. Anyone else want to take a crack at how
the
> > > regions from this report are taken from the tables using
Crystal
> > > Reports?
> > >
>
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing software
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing+
>
software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda
>
+database+software&w5=Database+management+software&w6=Database+market
ing+soft
> ware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> Membership database
software
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufact
>
uring+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&
>
w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketin
> g+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> Database
mortgage
> software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufactur
>
ing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4
>
=Pda+database+software&w5=Database+management+software&w6=Database+ma
rketing+
> software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
> Pda database software
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+s
>
oftware&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+
>
database+software&w5=Database+management+software&w6=Database+marketi
ng+softw
> are&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database management
software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufact
>
uring+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&
>
w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketin
> g+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> Database
marketing
> software
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftware&w
>
4=Pda+database+software&w5=Database+management+software&w6=Database+m
arketing
> +software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> ________________________________
>
>
>
>
> [Non-text portions of this message have been removed]
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda
+database+software&w5=Database+management+software&w6=Database+marketing+soft
ware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketin
g+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> Database mortgage
software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4
=Pda+database+software&w5=Database+management+software&w6=Database+marketing+
software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+s
oftware&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+
database+software&w5=Database+management+software&w6=Database+marketing+softw
are&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketin
g+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> Database marketing
software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&w
4=Pda+database+software&w5=Database+management+software&w6=Database+marketing
+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]