BAQ & Dashboard

system · June 19, 2009, 3:35am

Hi Bruce,

Can you remind me what the difference is between an inner and outer join?

Cheers.

________________________________
From: Bruce Larson <epicor@...>
To: vantage@yahoogroups.com
Sent: Thursday, 18 June, 2009 17:37:29
Subject: RE: [Vantage] BAQ & Dashboard

To delete the links - select the link and go to the table relations sheet
and click on the delete icon.

In E9 to create a new link, click on the Add Connection ("Chain" icon)
Click on the first and second table that you want to link.
Note that it defaults to an inner join.
To modify the link, click on the specific link and go to the Table Relations
sheet.

Bruce
bruce@ERPgeek. com
www.ERPgeek. com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Chris Thompson
Sent: Thursday, June 18, 2009 10:04 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

How do you remove an epicor link between table and creat your own?

In E9 I think it is more complicated?

____________ _________ _________ __
From: Robert Brown <robertb_versa@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 17:53:40
Subject: Re: [Vantage] BAQ & Dashboard

The BAQ wizard rarely creates joins in the way you need (when the query is
even moderately complex). Get used to establishing your own joins that suit
your specific needs.

Rob Brown

____________ _________ _________ __
From: Chris Thompson <chriselectrix@ ymail.com>
To: vantage@yahoogroups .com
Sent: Wednesday, June 17, 2009 11:51:48 AM
Subject: Re: [Vantage] BAQ & Dashboard

As soon as I add the JobHead table it increase the number of lines.

Which table relations should I be using?

It has automatically connect with JobHead as the Parent and JobOper as the
child with Company and JobNum as the relations.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 16:43:23
Subject: RE: [Vantage] BAQ & Dashboard

Add the jobhead table...part can come from there...if you need the
description as well, then add the part table to that!

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 10:38 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I think I have it almost.

I have linked the JobOper to LaborDtl in the opposite direction and that
is pulling through the correct Opr Descriptions.

The only thing now is to bring in the part number from somewhere. But
where? I have added it from the JobOper table and it displays a black
field so Im guessing its not that one! :-)

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 16:30:51
Subject: RE: [Vantage] BAQ & Dashboard

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations.. ..

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

[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]

[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]

[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]

system · June 17, 2009, 10:23am

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job and operation an operator has done and how long it took them, and how many parts they worked on.

I want to know the following:

DateÂ |Â Operator Name |Â Start TimeÂ |Â End Time |Â Job Number |Â PartÂ |Â Operation |Â Quantity |Â Standard Time |Â Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

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

system · June 17, 2009, 10:26am

Labor tables...labor head and labor dtl specifically...and also emp
basic (if it is still called that) to get the name of the operator.

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

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

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

system · June 17, 2009, 10:29am

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

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

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

system · June 17, 2009, 10:35am

No, I know how to create a BAQ, but I need to pull in the OprDescription and the qty that the operator has worked on.

Â

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

system · June 17, 2009, 10:42am

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

________________________________
From: Manasa Reddy <manasa@... <mailto:manasa%40weldcoa.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

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

system · June 17, 2009, 10:58am

I have added the OpMaster table but that has just added hundreds or repeat lines.

Will that be something to do with the join or table relationship or am I on the wrong table.

Cheers,

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

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

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

system · June 17, 2009, 11:10am

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

________________________________
From: Manasa Reddy <manasa@... <mailto:manasa%40weldcoa.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

system · June 17, 2009, 11:14am

Hi Group

________________________________

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=79332/stime=1245250713/nc1=3848644/nc2=5522132/nc3=5689702>
I am on Vantage 8.03 407A Multi Company and Multi Plant - OneDatabase

Is there a checklist as how to set up a part and PO for consolidated
purchasing.

I want to consolidate the PO for all companies for common parts. But am
not sure where to begin

I called support they said I need a consultant. I don't want a
consultant I just want to know what I need to do so I can test.

Is anyone else using this functionality and could you help me get it
set up

I would greatly appreciate it

Thank You

Don

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

system · June 17, 2009, 11:16am

In the BAQ Im not currently filtering.

I am wanting to see every employee (shopfloor) and see everything that they have done in date order and when the clocked on/off the job and which job and the opr description.

Im so close - but so far away!

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:09:39
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

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

system · June 17, 2009, 11:18am

Can you send me your links, because my report doesn't give all
operations....

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

________________________________
From: Manasa Reddy <manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

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

system · June 17, 2009, 11:19am

Go for JobOper. Then link it on jobnum and oprseq.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or repeat
lines.

Will that be something to do with the join or table relationship or am I on
the wrong table.

Cheers,

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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

system · June 17, 2009, 11:31am

Ross,

I have just tried linking LaborDtl (each) as the ParentTable to JobOper (each) as the child and created a table relations between JobNum and OrpSeq in both tables.

Is this what you meant?

It doesn't seem to have worked. Have I linked JobOper to the right table? in the right direction?

Cheers.

________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:19:30
Subject: RE: [Vantage] BAQ & Dashboard

Go for JobOper. Then link it on jobnum and oprseq.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or repeat
lines.

Will that be something to do with the join or table relationship or am I on
the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

system · June 17, 2009, 11:31am

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations....

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

________________________________
From: Manasa Reddy <manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

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

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

system · June 17, 2009, 11:38am

I think I have it almost.

I have linked the JobOper to LaborDtl in the opposite direction and that is pulling through the correct Opr Descriptions.

The only thing now is to bring in the part number from somewhere. But where? I have added it from the JobOper table and it displays a black field so Im guessing its not that one! :-)

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:30:51
Subject: RE: [Vantage] BAQ & Dashboard

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations.. ..

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

[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]

system · June 17, 2009, 11:44am

Add the jobhead table...part can come from there...if you need the
description as well, then add the part table to that!

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 10:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

I think I have it almost.

I have linked the JobOper to LaborDtl in the opposite direction and that
is pulling through the correct Opr Descriptions.

The only thing now is to bring in the part number from somewhere. But
where? I have added it from the JobOper table and it displays a black
field so Im guessing its not that one! :-)

________________________________
From: Manasa Reddy <manasa@... <mailto:manasa%40weldcoa.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, 17 June, 2009 16:30:51
Subject: RE: [Vantage] BAQ & Dashboard

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations.. ..

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

[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]

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

system · June 17, 2009, 11:44am

Chris,

I don't see your email in the header information.

Send your email directly to me and I will send you an XML file.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Wednesday, June 17, 2009 10:31 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

Ross,

I have just tried linking LaborDtl (each) as the ParentTable to JobOper
(each) as the child and created a table relations between JobNum and OrpSeq
in both tables.

Is this what you meant?

It doesn't seem to have worked. Have I linked JobOper to the right table? in
the right direction?

Cheers.

________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:19:30
Subject: RE: [Vantage] BAQ & Dashboard

Go for JobOper. Then link it on jobnum and oprseq.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or repeat
lines.

Will that be something to do with the join or table relationship or am I on
the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

------------------------------------

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

system · June 17, 2009, 11:52am

As soon as I add the JobHead table it increase the number of lines.

Which table relations should I be using?

It has automatically connect with JobHead as the Parent and JobOper as the child with Company and JobNum as the relations.

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:43:23
Subject: RE: [Vantage] BAQ & Dashboard

Add the jobhead table...part can come from there...if you need the
description as well, then add the part table to that!

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 10:38 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I think I have it almost.

I have linked the JobOper to LaborDtl in the opposite direction and that
is pulling through the correct Opr Descriptions.

The only thing now is to bring in the part number from somewhere. But
where? I have added it from the JobOper table and it displays a black
field so Im guessing its not that one! :-)

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 16:30:51
Subject: RE: [Vantage] BAQ & Dashboard

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations.. ..

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

[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]

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

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

system · June 17, 2009, 11:53am

Hi Ross,

it's chriselectrix@....

What do I have to do with the XML file?

________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:44:27
Subject: RE: [Vantage] BAQ & Dashboard

Chris,

I don't see your email in the header information.

Send your email directly to me and I will send you an XML file.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Chris Thompson
Sent: Wednesday, June 17, 2009 10:31 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

Ross,

I have just tried linking LaborDtl (each) as the ParentTable to JobOper
(each) as the child and created a table relations between JobNum and OrpSeq
in both tables.

Is this what you meant?

It doesn't seem to have worked. Have I linked JobOper to the right table? in
the right direction?

Cheers.

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 16:19:30
Subject: RE: [Vantage] BAQ & Dashboard

Go for JobOper. Then link it on jobnum and oprseq.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or repeat
lines.

Will that be something to do with the join or table relationship or am I on
the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

------------ --------- --------- ------

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]

system · June 17, 2009, 11:54am

It is the jobhead table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Wednesday, June 17, 2009 10:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ & Dashboard

I think I have it almost.

I have linked the JobOper to LaborDtl in the opposite direction and that is
pulling through the correct Opr Descriptions.

The only thing now is to bring in the part number from somewhere. But where?
I have added it from the JobOper table and it displays a black field so Im
guessing its not that one! :-)

________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 17 June, 2009 16:30:51
Subject: RE: [Vantage] BAQ & Dashboard

Just thinking that since you only want qty reported, correct? Then
filter for qty greater than zero....

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:18 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BAQ & Dashboard

Can you send me your links, because my report doesn't give all
operations.. ..

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, June 17, 2009 10:10 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BAQ & Dashboard

It should be a straight forward join....

How are you filtering?

I'm wondering if you need to join the JobOper table to get only the
operations on the job?

I'll do this in crystal and see what happens as well...

M. Manasa Reddy
manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:57 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] BAQ & Dashboard

I have added the OpMaster table but that has just added hundreds or
repeat lines.

Will that be something to do with the join or table relationship or am I
on the wrong table.

Cheers,

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com>
<mailto:manasa% 40weldcoa. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:37:54
Subject: RE: [Vantage] BAQ & Dashboard

qty is in the labor dtl table...the qty the operator finished.

I think you can link the operation table to the labor dtl table as well

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:35 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ & Dashboard

No, I know how to create a BAQ, but I need to pull in the OprDescription
and the qty that the operator has worked on.

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com <mailto:manasa% 40weldcoa. com>

>

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wednesday, 17 June, 2009 15:29:27
Subject: RE: [Vantage] BAQ & Dashboard

Unless you were asking how to create a BAQ....?

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Chris Thompson
Sent: Wednesday, June 17, 2009 9:23 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAQ & Dashboard

Hi,

Im trying to create a simple (or so I thought) BAQ to report what job
and operation an operator has done and how long it took them, and how
many parts they worked on.

I want to know the following:

Date | Operator Name | Start Time | End Time | Job Number | Part |
Operation | Quantity | Standard Time | Type

Does any know where I should begin?

Does anyone have a BAQ like this that I may 'aquire'?

Thanks,

CHRIS THOMPSON

[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]

[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]

[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]

------------------------------------

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

Topic		Replies	Views
BAQ Report Query Question Yahoo Archive	5	358	February 4, 2009
BAQ - Linking table in a second time Yahoo Archive	3	326	March 2, 2011
BAQ Help Blank Title 57176 Yahoo Archive	33	1079	September 25, 2014
Help Yahoo Archive	25	1507	October 1, 2007
Epicor 9 BAQ Blank Title 82349 Yahoo Archive	3	405	September 2, 2009

BAQ & Dashboard

Related Topics