Cliff,
If you take a look at the Data Dictionary you will find an index for
LaborDtl called
JOBASMSEQ: Company,JobNum,AssemblySeq,OprSeq
When joining to JobOper you need to make these four links:
Company,JobNum,AssemblySeq,OprSeq
Bob Morgan
Modern Tool, Inc
612.804.3096
rjmorgan@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Cliff Drumeller
Sent: Thursday, June 30, 2005 11:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report help
Hey All
An Opportunity - I have two simple report builder reports pictured below.
The first is a single table pull from JobOper. The second is a single table
pull from LaborDtl. I'm trying to combine the two by joining on company and
job number. Result is a mushroom cloud. It turns a 3 page report into a
nineteen page report with data from whenever the job started not the
required day.
Has anyone succeeded in creating something close and could give me a hand.
The result would be an excellent report if I could get it to work.
Help Please
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 217
408 314 7420 cell
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
If you take a look at the Data Dictionary you will find an index for
LaborDtl called
JOBASMSEQ: Company,JobNum,AssemblySeq,OprSeq
When joining to JobOper you need to make these four links:
Company,JobNum,AssemblySeq,OprSeq
Bob Morgan
Modern Tool, Inc
612.804.3096
rjmorgan@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Cliff Drumeller
Sent: Thursday, June 30, 2005 11:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report help
Hey All
An Opportunity - I have two simple report builder reports pictured below.
The first is a single table pull from JobOper. The second is a single table
pull from LaborDtl. I'm trying to combine the two by joining on company and
job number. Result is a mushroom cloud. It turns a 3 page report into a
nineteen page report with data from whenever the job started not the
required day.
Has anyone succeeded in creating something close and could give me a hand.
The result would be an excellent report if I could get it to work.
Help Please
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 217
408 314 7420 cell
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links