BAQ: Summary Tables in E9

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?

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]
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]
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]
Joe, that has completely changed. Here is the answer from Epicor answer book
Â
Summary:Â Â Â Â Â Â Â BAQ How to set the summarized field in a BAQ on Epicor 9
Book:Â Â Â Â Â Â Â Â Â Support Solutions
Page:Â Â Â Â Â Â Â Â Â 8781ESC

PAGE
8781ESC

SUMMARY:
How to set the summarized field in a BAQ on Epicor 9.Â

DESCRIPTION:
The Summarize checkbox used in 8.03.4xx and below is no longer available in
EPicor 9 so how do I summarize a table? In Epicor 9 adding a calculation that
uses a aggregate calculation will cause the system to automatically summarize
your table. Aggregate functions are - Average, Count, and Total.

Example to summarize fields for PODetail
- Go to Systems Management > Utilities > BAQ Designer
- On the Phase Builder sheet drag both the POHeader and then the PODetail to the
grid.
- On Display tab, select fields from POHeader
- Click the calculator icon and create the follow expression
       TOTAL(PODetail.OrderQty * PODetail.UnitCost)
- Save and test your BAQ

You'll find that the PODetail table has been summarized.

VERSION
9.04.5XX





________________________________
From: Joe Rojas <jrojas@...>
To: vantage@yahoogroups.com
Sent: Mon, March 7, 2011 1:40:22 PM
Subject: [Vantage] BAQ: Summary Tables in E9

Â
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]
Thanks Mark (and Waffqle)!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, March 07, 2011 3:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ: Summary Tables in E9





Joe, that has completely changed. Here is the answer from Epicor answer book

Summary: BAQ How to set the summarized field in a BAQ on Epicor 9
Book: Support Solutions
Page: 8781ESC

PAGE
8781ESC

SUMMARY:
How to set the summarized field in a BAQ on Epicor 9.

DESCRIPTION:
The Summarize checkbox used in 8.03.4xx and below is no longer available in
EPicor 9 so how do I summarize a table? In Epicor 9 adding a calculation that
uses a aggregate calculation will cause the system to automatically summarize
your table. Aggregate functions are - Average, Count, and Total.

Example to summarize fields for PODetail
- Go to Systems Management > Utilities > BAQ Designer
- On the Phase Builder sheet drag both the POHeader and then the PODetail to the
grid.
- On Display tab, select fields from POHeader
- Click the calculator icon and create the follow expression
TOTAL(PODetail.OrderQty * PODetail.UnitCost)
- Save and test your BAQ

You'll find that the PODetail table has been summarized.

VERSION
9.04.5XX












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.



________________________________

From: Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, March 7, 2011 1:40:22 PM
Subject: [Vantage] BAQ: Summary Tables in E9


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@... <mailto:jrojas%40matsinc.com> | 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]




[Non-text portions of this message have been removed]
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/.%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]
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]
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/.%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]
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]
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/.%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]
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]
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/.%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]
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]
That seems to work.

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/.%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]
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/.%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]
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]