Frank,
I have Jobhead joined to Joboper using company, Jobnum, and
jobcomplete (looking at it again, and wondering why I used
jobcomplete, but it shouldn't make a difference).
Then the joboper table is joined with the wrkcntr table using company
and wccode.
This is where I left it. The previous response to this from another
vantage user to group on Job got me closer, but it still put info on
different lines due to the grouping.
I have left the report builder, and used Access. I dumped a bunch of
data and was able to get it.
Thanks all for your help!
Andrew
--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
access. )
http://groups.yahoo.com/group/vantage/files/.
6/D=groups/S=1705007183:HM/EXP=1099067405/A=2372354/R=0/SIG=12id813k2/
*https://www.orchardbank.com/hcs/hcsapplication?
pf=PLApply&media=EMYHNL40F21004SS> click here
54>
The email and any files transmitted with it are confidential to the
intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that
addressee, nor may it be copied in any way. If received in error,
please delete and notify the sender via e-mail or sales@L... quoting
the name of the sender. Messages sent via this medium may be subject
to delays, non-delivery and unauthorized alteration. This e-mail has
been prepared using information believed by the author to be reliable
and accurate. Unless expressly stated otherwise, this e-mail does not
form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
email, we cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. It is, therefore, your
responsibility to scan attachments (if any).
I have Jobhead joined to Joboper using company, Jobnum, and
jobcomplete (looking at it again, and wondering why I used
jobcomplete, but it shouldn't make a difference).
Then the joboper table is joined with the wrkcntr table using company
and wccode.
This is where I left it. The previous response to this from another
vantage user to group on Job got me closer, but it still put info on
different lines due to the grouping.
I have left the report builder, and used Access. I dumped a bunch of
data and was able to get it.
Thanks all for your help!
Andrew
--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> how do you have the tables joined on what fields?to
>
> -----Original Message-----
> From: andrewcretors [mailto:acretors@c...]
> Sent: Thursday, October 28, 2004 12:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report builder join question
>
>
>
> To all,
> I am trying to create a report that counts the number of times each
> part number was run through a given department. The summary output
> would be:
> Part Number, Number of times it was run through the department, and
> average run quantity.
>
> I have the following tables already in the report: Jobhead joined
> JobOper. JobOper joined to Wrkcenter. I am counting the jobnumberto
> get a count of how many times it was run.part
>
> The output I get is close, but it prints the detail records as many
> times as there are operations on the job. For example, let's say
> ABC has 3 operations on it, and we ran it 2 times in the past 12pieces,
> months. The detail output I am getting is:
> Part Number, Job Number, Quantity
> abc,JOB1,500
> abc,Job1,500
> abc,Job1,500
> abc,job2,700
> abc,job2,700
> abc,job2,700
>
> Then the summary data says that we ran 6 jobs, total of 3753
> average run size 600. The detail output I want is:I
> abc,job1,500
> abc,job2,700
> with the summary data of; Ran it twice, average of 600
>
> I hope this makes sense without getting too bogged down in details.
> am wondering if I am using the right tables etc. Can anyone offerany
> guidance?must have already linked your email address to a yahoo id to enable
>
> Thanks in advance!
> Andrew
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
access. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:http://groups.yahoo.com/group/vantage/links
><http://us.ard.yahoo.com/SIG=12941b09a/M=315388.5529720.6602079.300117
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
6/D=groups/S=1705007183:HM/EXP=1099067405/A=2372354/R=0/SIG=12id813k2/
*https://www.orchardbank.com/hcs/hcsapplication?
pf=PLApply&media=EMYHNL40F21004SS> click here
> <http://us.adserver.yahoo.com/l?M=315388.5529720.6602079.3001176/D=groups/S=:HM/A=2372354/rand=5127753
54>
>unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
>Service <http://docs.yahoo.com/info/terms/> .
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>and keyboards
>
>
> <www.LCDarms.com> -- Ergonomic mounting solutions for monitors
>the views of the sender and not necessarily the views of the company.
> This e-mail is from Innovative Office Products, Inc. but expresses
The email and any files transmitted with it are confidential to the
intended recipient at the e-mail address to which it has been
addressed. It may not be disclosed or used by any other than that
addressee, nor may it be copied in any way. If received in error,
please delete and notify the sender via e-mail or sales@L... quoting
the name of the sender. Messages sent via this medium may be subject
to delays, non-delivery and unauthorized alteration. This e-mail has
been prepared using information believed by the author to be reliable
and accurate. Unless expressly stated otherwise, this e-mail does not
form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.
>reasonable precautions to ensure no viruses are present in this
> Warning: Although Innovative Office Products, Inc. has taken
email, we cannot accept responsibility for any loss or damage arising
from the use of this email or attachments. It is, therefore, your
responsibility to scan attachments (if any).
>
>
>
> [Non-text portions of this message have been removed]