I have JobHead < JobOper
I am displaying JobHead.JobNum, JobOper.JobNum and JobOper.OprSeq
I have chosen First on JobOper.
This works fine.
However, if I add a criteria on JobOper for OpComplete = FALSE, the results are
not accurate.
At first glance they are but after a while you find that SOME are displaying the
incorrect info.
They might display e.g. OprSeq 60 when the first one that isnt complete is
OprSeq 30.
________________________________
From: Waffqle <waffqle@...>
To: vantage@yahoogroups.com
Sent: Wed, 9 March, 2011 13:43:22
Subject: Re: [Vantage] BAQ: Summary Tables in E9
Can you give us an example of when it works/doesn't?
How is it not working? Are the total wrong?
I am displaying JobHead.JobNum, JobOper.JobNum and JobOper.OprSeq
I have chosen First on JobOper.
This works fine.
However, if I add a criteria on JobOper for OpComplete = FALSE, the results are
not accurate.
At first glance they are but after a while you find that SOME are displaying the
incorrect info.
They might display e.g. OprSeq 60 when the first one that isnt complete is
OprSeq 30.
________________________________
From: Waffqle <waffqle@...>
To: vantage@yahoogroups.com
Sent: Wed, 9 March, 2011 13:43:22
Subject: Re: [Vantage] BAQ: Summary Tables in E9
Can you give us an example of when it works/doesn't?
How is it not working? Are the total wrong?
On Wed, Mar 9, 2011 at 4:18 AM, Chris Thompson <chriselectrix@...>wrote:
>
>
> Hi
>
> Upon further checking, it doesnt work fully.
>
> It works with some but not with others.
>
> Any suggestions?
>
>
> Thanks.
>
> ________________________________
> From: Waffqle <waffqle@...>
> To: vantage@yahoogroups.com
> Sent: Tue, 8 March, 2011 16:22:08
>
> Subject: Re: [Vantage] BAQ: Summary Tables in E9
>
> Set it as first, and sort it. That should do the trick.
>
> On Tue, Mar 8, 2011 at 10:51 AM, Chris Thompson <chriselectrix@...
> >wrote:
>
> >
> >
> > I've tried that but it didnt seem to work.
> >
> > Do you mean set up the JobOper table as 'First'?
> >
> >
> > ________________________________
> > From: Waffqle <waffqle@...>
> > To: vantage@yahoogroups.com
> > Sent: Tue, 8 March, 2011 15:48:36
> >
> > Subject: Re: [Vantage] BAQ: Summary Tables in E9
> >
> > Under "Display > Sort Order" on the BAQ designer.
> >
> > Set the JobOper table to sort by OprSeq and only retrieve the first
> record.
> >
> > On Tue, Mar 8, 2011 at 10:29 AM, Chris Thompson <chriselectrix@...
> > >wrote:
> >
> > >
> > >
> > > I already indirectly knew how to do that.
> > >
> > > Here's one for you -
> > >
> > > I have JobHead < JobOper.
> > >
> > > I want to see the next operation (JobOper.OprSeq) for each job that
> isnt
> > > complete.
> > >
> > > I.e. Job 45667 - operation 10, 20, 30, 40 are marked as complete.
> > Operation
> > > 50,
> > > 60, 70, 80, 90, 100 still remain.
> > >
> > > However I only want to see Job 45667 Operation 50 in the results of my
> > BAQ
> > > - I
> > > dont want to see 60 etc.
> > >
> > > I have tried using First on the join but it doesnt work like that as
> the
> > > operations might not necessarily follow on when the jobs were created.
> > >
> > > ie 45 might have been inserted between operation 40 and 50 after the
> > > BOM/Job was
> > > created, therefore 45 actually shows up at the end when the table is
> > > imported
> > > un-sorted.
> > >
> > > Any suggestion would be appreciated.
> > >
> > > Is there any kind of formula I can use to only show the next operation
> > that
> > >
> > > hasnt been complete?
> > >
> > > something like
> > >
> > > if joboper.oprseq = 40 and joboper.opcomplete = true then show next
> > oprseq?
> > >
> > > Thanks.
> > >
> > >
> > > ________________________________
> > > From: Waffqle <waffqle@...>
> > > To: vantage@yahoogroups.com
> > > Sent: Tue, 8 March, 2011 14:14:29
> > >
> > > Subject: Re: [Vantage] BAQ: Summary Tables in E9
> > >
> > > You got it.
> > > average(OrderHed.OrderNum)
> > > You still need to add the table to the report, just don't use any of
> the
> > > fields directly.
> > >
> > > On Tue, Mar 8, 2011 at 9:09 AM, Chris Thompson <
> chriselectrix@...
> > > >wrote:
> > >
> > > >
> > > >
> > > > So how does it know which table to summarise? Or is 'x' replaced by
> the
> > > > field
> > > > name?
> > > >
> > > >
> > > > ________________________________
> > > > From: Waffqle <waffqle@...>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Tue, 8 March, 2011 13:11:41
> > > >
> > > > Subject: Re: [Vantage] BAQ: Summary Tables in E9
> > > >
> > > > The UI will give you a tree where you can choose the functions you
> > like.
> > > > Put
> > > > the format is:
> > > > average(x)
> > > > count(x)
> > > > etc.
> > > >
> > > > On Tue, Mar 8, 2011 at 5:21 AM, Chris Thompson <
> > chriselectrix@...
> > > > >wrote:
> > > >
> > > > >
> > > > >
> > > > > So what would the calculated field look like?
> > > > >
> > > > > ________________________________
> > > > > From: Waffqle <waffqle@...>
> > > > > To: vantage@yahoogroups.com
> > > > > Sent: Mon, 7 March, 2011 20:04:29
> > > > >
> > > > > Subject: Re: [Vantage] BAQ: Summary Tables in E9
> > > > >
> > > > > Just add the table to the BAQ and create calculated fields without
> > > > setting
> > > > > any of the normal fields to display. As far as I've seen, this
> > provides
> > > > the
> > > > > same functionality.
> > > > >
> > > > > On Mon, Mar 7, 2011 at 1:40 PM, Joe Rojas <jrojas@...>
> > wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > I noticed that the checkbox to make a table a summary table, in
> the
> > > BAQ
> > > > > > Designer, is not available in E9 as it was in V8.
> > > > > >
> > > > > > How do you create a summary table or simulate this feature in E9?
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Joe Rojas | Director of Information Technology | Mats Inc
> > > > > > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > > > > > jrojas@... | www.matsinc.com Ask us about our clean,
> green
> > > and
> > > > > > beautiful matting and flooring
> > > > > >
> > > > > > This message is intended only for the individual named. If you
> are
> > > not
> > > > > the
> > > > > > named addressee you should not disseminate, distribute or copy
> this
> > > > > e-mail.
> > > > > > Please notify the sender immediately by e-mail if you have
> received
> > > > this
> > > > > > e-mail by mistake. Please note that any views or opinions
> presented
> > > in
> > > > > this
> > > > > > email are solely those of the author and do not necessarily
> > represent
> > > > > those
> > > > > > of the company.
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > [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/linksYahoo! Groups Links
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > > [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/linksYahoo! Groups Links
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > [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/linksYahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>Â
>
[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/.%c2%a0
(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/linksYahoo! Groups Links
[Non-text portions of this message have been removed]