Crystal Reports [bayes]

Yahoo Archive
1
You are right. I was thinking of the related operation field. Sorry.

Brian

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> is the last link right JobOper.OprSeq ->JobMtl.MtlSeq? they really
have no
> relationship together.
>
>
>
> Frank Zeigafuse
>
> Innovative Office Products
>
> General Manager
>
> Direct Phone: 610-559-6369
>
> Email: fzeigafuse@L...
>
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 8:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> John,
>
> I would look carefully at the links you used to the JobMtl Table.
If
> you get no records after adding a field from that table I would bet
> that its not properly linked. What fields are you linking on?
>
> JobOper.Company ->JobMtl.Company
> JobOper.JobNum ->JobMtl.JobNum
> JobOper.AssemblySeq ->JobMtl.AssemblySeq
> JobOper.OprSeq ->JobMtl.MtlSeq
>
> This should be the correct linking. As Dan mentioned, a left join
> would give you all Job Operations whether or not there is a
> corresponding record in the Job Mtl Table. One other thought that
> occurred to me while typing this, is that if you don't have a
related
> operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be
0,
> the above joins would return no records unless you made it a left
> join.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
> wrote:
> > Dan
> >
> > The only filters on the Job reports have been for closed jobs or
> > completed line.
> >
> > For example, My Shop Forman wants to know what Jobs, associated
> > operations, assemblies and material for that job are remaining
> open. to
> > start, I create a blank report and attach the ODBC database(s) of
> the
> > JobOper and JobMtl files. I then insert the jobnum file, the
index
> in
> > both files, the Seqnum and OperSeq from the JobOper file. I
select
> > records by JobClosed="false". That works. I add any field from
the
> > JobMtl and re-run the query and get no records as a result.
> >
> > I've done this before (not on Progress databases) and can get it
to
> > work, but I'm missing something simple. Vantage Product Support
is
> > stumped and I have asked for their Crystal guru, but he hasn't
> called
> > back.
> >
> > John,
> >
> > Are you using any report filters on either the main or the
> subreport?
> > What section of the main report did you place the subreport into?
> Are
> > you linking the subreport to the main report? What are the
results
> that
> > your report returns? error messages?
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Wednesday, September 08, 2004 2:59 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > yes, the Progress ODBC drivers are installed and I am able to
> access the
> > files one at a time. But I am unable to link files for
> Header/Detail
> > information.
> >
> >
> >
> >
> >
> >
> >
> > [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
>
>
>
> 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 Sponsor
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=1294vvtvj/M=295196.4901138.6071305.300117
6/D=gr
>
oups/S=1705007183:HM/EXP=1094820751/A=2128215/R=0/SIG=10se96mf6/*http:
//comp
> anion.yahoo.com> click here
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=groups/S=
> :HM/A=2128215/rand=762863764>
>
>
> _____
>
> 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-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
> <www.LCDarms.com> -- Ergonomic mounting solutions for monitors
and keyboards
>
> This e-mail is from Innovative Office Products, Inc. but expresses
the views of the sender and not necessarily the views of the company.
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.
>
> Warning: Although Innovative Office Products, Inc. has taken
reasonable precautions to ensure no viruses are present in this
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]
2
yes, the Progress ODBC drivers are installed and I am able to access the
files one at a time. But I am unable to link files for Header/Detail
information.
3
John,

Are you using any report filters on either the main or the subreport? What
section of the main report did you place the subreport into? Are you linking
the subreport to the main report? What are the results that your report
returns? error messages?

Dan Shallbetter
States Electric Mfg.






-----Original Message-----
From: Kathy Schmidt [mailto:kathyschmidt@...]
Sent: Wednesday, September 08, 2004 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports [bayes]


yes, the Progress ODBC drivers are installed and I am able to access the
files one at a time. But I am unable to link files for Header/Detail
information.







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

The only filters on the Job reports have been for closed jobs or
completed line.

For example, My Shop Forman wants to know what Jobs, associated
operations, assemblies and material for that job are remaining open. to
start, I create a blank report and attach the ODBC database(s) of the
JobOper and JobMtl files. I then insert the jobnum file, the index in
both files, the Seqnum and OperSeq from the JobOper file. I select
records by JobClosed="false". That works. I add any field from the
JobMtl and re-run the query and get no records as a result.

I've done this before (not on Progress databases) and can get it to
work, but I'm missing something simple. Vantage Product Support is
stumped and I have asked for their Crystal guru, but he hasn't called
back.

John,

Are you using any report filters on either the main or the subreport?
What section of the main report did you place the subreport into? Are
you linking the subreport to the main report? What are the results that
your report returns? error messages?

Dan Shallbetter
States Electric Mfg.






-----Original Message-----
From: Kathy Schmidt [mailto:kathyschmidt@...]
Sent: Wednesday, September 08, 2004 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports [bayes]


yes, the Progress ODBC drivers are installed and I am able to access the
files one at a time. But I am unable to link files for Header/Detail
information.







[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
5
John,

I typically design my reports using a one to many join for faster
processing, or the table I am using for my primary filter. I would start
with the Jobhead file first, it sounds like using all left joins should work
for your report. I am not a Crystal guru, but send it to me directly and
I'll take a quick peak at it in the morning if you'd like.

Dan Shallbetter
States Electric

-----Original Message-----
From: Kathy Schmidt [mailto:kathyschmidt@...]
Sent: Wednesday, September 08, 2004 4:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports [bayes]


Dan

The only filters on the Job reports have been for closed jobs or
completed line.

For example, My Shop Forman wants to know what Jobs, associated
operations, assemblies and material for that job are remaining open. to
start, I create a blank report and attach the ODBC database(s) of the
JobOper and JobMtl files. I then insert the jobnum file, the index in
both files, the Seqnum and OperSeq from the JobOper file. I select
records by JobClosed="false". That works. I add any field from the
JobMtl and re-run the query and get no records as a result.

I've done this before (not on Progress databases) and can get it to
work, but I'm missing something simple. Vantage Product Support is
stumped and I have asked for their Crystal guru, but he hasn't called
back.

John,

Are you using any report filters on either the main or the subreport?
What section of the main report did you place the subreport into? Are
you linking the subreport to the main report? What are the results that
your report returns? error messages?

Dan Shallbetter
States Electric Mfg.






-----Original Message-----
From: Kathy Schmidt [mailto:kathyschmidt@...]
Sent: Wednesday, September 08, 2004 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports [bayes]


yes, the Progress ODBC drivers are installed and I am able to access the
files one at a time. But I am unable to link files for Header/Detail
information.







[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links







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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=1296vlq1m/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1094765266/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=383718973>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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

I would look carefully at the links you used to the JobMtl Table. If
you get no records after adding a field from that table I would bet
that its not properly linked. What fields are you linking on?

JobOper.Company ->JobMtl.Company
JobOper.JobNum ->JobMtl.JobNum
JobOper.AssemblySeq ->JobMtl.AssemblySeq
JobOper.OprSeq ->JobMtl.MtlSeq

This should be the correct linking. As Dan mentioned, a left join
would give you all Job Operations whether or not there is a
corresponding record in the Job Mtl Table. One other thought that
occurred to me while typing this, is that if you don't have a related
operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be 0,
the above joins would return no records unless you made it a left
join.

HTH,

Brian Stenglein
Clow Stamping Co.





--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> Dan
>
> The only filters on the Job reports have been for closed jobs or
> completed line.
>
> For example, My Shop Forman wants to know what Jobs, associated
> operations, assemblies and material for that job are remaining
open. to
> start, I create a blank report and attach the ODBC database(s) of
the
> JobOper and JobMtl files. I then insert the jobnum file, the index
in
> both files, the Seqnum and OperSeq from the JobOper file. I select
> records by JobClosed="false". That works. I add any field from the
> JobMtl and re-run the query and get no records as a result.
>
> I've done this before (not on Progress databases) and can get it to
> work, but I'm missing something simple. Vantage Product Support is
> stumped and I have asked for their Crystal guru, but he hasn't
called
> back.
>
> John,
>
> Are you using any report filters on either the main or the
subreport?
> What section of the main report did you place the subreport into?
Are
> you linking the subreport to the main report? What are the results
that
> your report returns? error messages?
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Wednesday, September 08, 2004 2:59 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> yes, the Progress ODBC drivers are installed and I am able to
access the
> files one at a time. But I am unable to link files for
Header/Detail
> information.
>
>
>
>
>
>
>
> [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
7
Brian

I have verified the links and Crystal says they are there, but the green
"home plate" icon I was used to in V6-7 isn't there? I have looked at
some of the default reports and that icon shows up. Do you have it/

John

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, September 09, 2004 7:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Crystal Reports [bayes]


John,

I would look carefully at the links you used to the JobMtl Table. If
you get no records after adding a field from that table I would bet
that its not properly linked. What fields are you linking on?

JobOper.Company ->JobMtl.Company
JobOper.JobNum ->JobMtl.JobNum
JobOper.AssemblySeq ->JobMtl.AssemblySeq
JobOper.OprSeq ->JobMtl.MtlSeq

This should be the correct linking. As Dan mentioned, a left join
would give you all Job Operations whether or not there is a
corresponding record in the Job Mtl Table. One other thought that
occurred to me while typing this, is that if you don't have a related
operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be 0,
the above joins would return no records unless you made it a left
join.

HTH,

Brian Stenglein
Clow Stamping Co.





--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> Dan
>
> The only filters on the Job reports have been for closed jobs or
> completed line.
>
> For example, My Shop Forman wants to know what Jobs, associated
> operations, assemblies and material for that job are remaining
open. to
> start, I create a blank report and attach the ODBC database(s) of
the
> JobOper and JobMtl files. I then insert the jobnum file, the index
in
> both files, the Seqnum and OperSeq from the JobOper file. I select
> records by JobClosed="false". That works. I add any field from the
> JobMtl and re-run the query and get no records as a result.
>
> I've done this before (not on Progress databases) and can get it to
> work, but I'm missing something simple. Vantage Product Support is
> stumped and I have asked for their Crystal guru, but he hasn't
called
> back.
>
> John,
>
> Are you using any report filters on either the main or the
subreport?
> What section of the main report did you place the subreport into?
Are
> you linking the subreport to the main report? What are the results
that
> your report returns? error messages?
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Wednesday, September 08, 2004 2:59 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> yes, the Progress ODBC drivers are installed and I am able to
access the
> files one at a time. But I am unable to link files for
Header/Detail
> information.
>
>
>
>
>
>
>
> [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




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
8
John,

The icon you refer to only shows up in the Crystal Forms that Epicor
creates from the DBF files. It is not there for the ODBC linked
tables. Are you saying that you've linked the tables as I
described? Have you verified that you have used a related operation
in the Matl Records. Have you tried changing the join type to a left
outer join?

Brian


--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> Brian
>
> I have verified the links and Crystal says they are there, but the
green
> "home plate" icon I was used to in V6-7 isn't there? I have looked
at
> some of the default reports and that icon shows up. Do you have it/
>
> John
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 7:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> John,
>
> I would look carefully at the links you used to the JobMtl Table.
If
> you get no records after adding a field from that table I would bet
> that its not properly linked. What fields are you linking on?
>
> JobOper.Company ->JobMtl.Company
> JobOper.JobNum ->JobMtl.JobNum
> JobOper.AssemblySeq ->JobMtl.AssemblySeq
> JobOper.OprSeq ->JobMtl.MtlSeq
>
> This should be the correct linking. As Dan mentioned, a left join
> would give you all Job Operations whether or not there is a
> corresponding record in the Job Mtl Table. One other thought that
> occurred to me while typing this, is that if you don't have a
related
> operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be
0,
> the above joins would return no records unless you made it a left
> join.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
> wrote:
> > Dan
> >
> > The only filters on the Job reports have been for closed jobs or
> > completed line.
> >
> > For example, My Shop Forman wants to know what Jobs, associated
> > operations, assemblies and material for that job are remaining
> open. to
> > start, I create a blank report and attach the ODBC database(s) of
> the
> > JobOper and JobMtl files. I then insert the jobnum file, the index
> in
> > both files, the Seqnum and OperSeq from the JobOper file. I
select
> > records by JobClosed="false". That works. I add any field from
the
> > JobMtl and re-run the query and get no records as a result.
> >
> > I've done this before (not on Progress databases) and can get it
to
> > work, but I'm missing something simple. Vantage Product Support
is
> > stumped and I have asked for their Crystal guru, but he hasn't
> called
> > back.
> >
> > John,
> >
> > Are you using any report filters on either the main or the
> subreport?
> > What section of the main report did you place the subreport into?
> Are
> > you linking the subreport to the main report? What are the results
> that
> > your report returns? error messages?
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Wednesday, September 08, 2004 2:59 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > yes, the Progress ODBC drivers are installed and I am able to
> access the
> > files one at a time. But I am unable to link files for
> Header/Detail
> > information.
> >
> >
> >
> >
> >
> >
> >
> > [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
>
>
>
>
> 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
9
John,

In thinking about this last night. Unless all your Jobs are only one level,
you might want to to try adding JobAsmbl
I would Join JobHead--- JobAsmbl, JobAsmbl to both Joboper & JobMatl. This
should show job material releated to each job assembly, providiing
subassemblies were created as pull as assembly

Dan Shallbetter
States Electric Mfg.



-----Original Message-----
From: Kathy Schmidt [mailto:kathyschmidt@...]
Sent: Thursday, September 09, 2004 8:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re:Crystal Reports [bayes]


Brian

I have verified the links and Crystal says they are there, but the green
"home plate" icon I was used to in V6-7 isn't there? I have looked at
some of the default reports and that icon shows up. Do you have it/

John

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, September 09, 2004 7:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Crystal Reports [bayes]


John,

I would look carefully at the links you used to the JobMtl Table. If
you get no records after adding a field from that table I would bet
that its not properly linked. What fields are you linking on?

JobOper.Company ->JobMtl.Company
JobOper.JobNum ->JobMtl.JobNum
JobOper.AssemblySeq ->JobMtl.AssemblySeq
JobOper.OprSeq ->JobMtl.MtlSeq

This should be the correct linking. As Dan mentioned, a left join
would give you all Job Operations whether or not there is a
corresponding record in the Job Mtl Table. One other thought that
occurred to me while typing this, is that if you don't have a related
operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be 0,
the above joins would return no records unless you made it a left
join.

HTH,

Brian Stenglein
Clow Stamping Co.





--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> Dan
>
> The only filters on the Job reports have been for closed jobs or
> completed line.
>
> For example, My Shop Forman wants to know what Jobs, associated
> operations, assemblies and material for that job are remaining
open. to
> start, I create a blank report and attach the ODBC database(s) of
the
> JobOper and JobMtl files. I then insert the jobnum file, the index
in
> both files, the Seqnum and OperSeq from the JobOper file. I select
> records by JobClosed="false". That works. I add any field from the
> JobMtl and re-run the query and get no records as a result.
>
> I've done this before (not on Progress databases) and can get it to
> work, but I'm missing something simple. Vantage Product Support is
> stumped and I have asked for their Crystal guru, but he hasn't
called
> back.
>
> John,
>
> Are you using any report filters on either the main or the
subreport?
> What section of the main report did you place the subreport into?
Are
> you linking the subreport to the main report? What are the results
that
> your report returns? error messages?
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Wednesday, September 08, 2004 2:59 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> yes, the Progress ODBC drivers are installed and I am able to
access the
> files one at a time. But I am unable to link files for
Header/Detail
> information.
>
>
>
>
>
>
>
> [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/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
<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://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links







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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129p196ji/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1094823625/A=2319498/R=0/SIG=11thfntfp/*http://www.
netflix.com/Default?mqso=60185352&partid=5285298> click here

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2319498/rand=549766936>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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

Good point about it being necessary for assembly jobs, but I don't
think this would cause him to get no records when adding the JobMtl
table.

Brian

--- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...> wrote:
> John,
>
> In thinking about this last night. Unless all your Jobs are only
one level,
> you might want to to try adding JobAsmbl
> I would Join JobHead--- JobAsmbl, JobAsmbl to both Joboper &
JobMatl. This
> should show job material releated to each job assembly, providiing
> subassemblies were created as pull as assembly
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Thursday, September 09, 2004 8:37 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> Brian
>
> I have verified the links and Crystal says they are there, but the
green
> "home plate" icon I was used to in V6-7 isn't there? I have looked
at
> some of the default reports and that icon shows up. Do you have it/
>
> John
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 7:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> John,
>
> I would look carefully at the links you used to the JobMtl Table.
If
> you get no records after adding a field from that table I would bet
> that its not properly linked. What fields are you linking on?
>
> JobOper.Company ->JobMtl.Company
> JobOper.JobNum ->JobMtl.JobNum
> JobOper.AssemblySeq ->JobMtl.AssemblySeq
> JobOper.OprSeq ->JobMtl.MtlSeq
>
> This should be the correct linking. As Dan mentioned, a left join
> would give you all Job Operations whether or not there is a
> corresponding record in the Job Mtl Table. One other thought that
> occurred to me while typing this, is that if you don't have a
related
> operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be
0,
> the above joins would return no records unless you made it a left
> join.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
> wrote:
> > Dan
> >
> > The only filters on the Job reports have been for closed jobs or
> > completed line.
> >
> > For example, My Shop Forman wants to know what Jobs, associated
> > operations, assemblies and material for that job are remaining
> open. to
> > start, I create a blank report and attach the ODBC database(s) of
> the
> > JobOper and JobMtl files. I then insert the jobnum file, the index
> in
> > both files, the Seqnum and OperSeq from the JobOper file. I
select
> > records by JobClosed="false". That works. I add any field from
the
> > JobMtl and re-run the query and get no records as a result.
> >
> > I've done this before (not on Progress databases) and can get it
to
> > work, but I'm missing something simple. Vantage Product Support
is
> > stumped and I have asked for their Crystal guru, but he hasn't
> called
> > back.
> >
> > John,
> >
> > Are you using any report filters on either the main or the
> subreport?
> > What section of the main report did you place the subreport into?
> Are
> > you linking the subreport to the main report? What are the results
> that
> > your report returns? error messages?
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Wednesday, September 08, 2004 2:59 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > yes, the Progress ODBC drivers are installed and I am able to
> access the
> > files one at a time. But I am unable to link files for
> Header/Detail
> > information.
> >
> >
> >
> >
> >
> >
> >
> > [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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
>
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129p196ji/M=298184.5285298.6392945.300117
6/D=gr
>
oups/S=1705007183:HM/EXP=1094823625/A=2319498/R=0/SIG=11thfntfp/*http:
//www.
> netflix.com/Default?mqso=60185352&partid=5285298> click here
>
> <http://us.adserver.yahoo.com/l?
M=298184.5285298.6392945.3001176/D=groups/S=
> :HM/A=2319498/rand=549766936>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
11
The only point I would add in is to make sure the joins mentioned are
the only joins...
If you let Crystal do it's default joining it will also connect the VB
fields Character01...Date01....
These should not be joined and might cause the problem if they were.
Just a thought.
Also, when you see the join line, double click on the join to make sure
it's left outer.
Hope this is of some help.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, September 09, 2004 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Crystal Reports [bayes]


Dan,

Good point about it being necessary for assembly jobs, but I
don't
think this would cause him to get no records when adding the
JobMtl
table.

Brian

--- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...>
wrote:
> John,
>
> In thinking about this last night. Unless all your Jobs are
only
one level,
> you might want to to try adding JobAsmbl
> I would Join JobHead--- JobAsmbl, JobAsmbl to both Joboper &
JobMatl. This
> should show job material releated to each job assembly,
providiing
> subassemblies were created as pull as assembly
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Thursday, September 09, 2004 8:37 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> Brian
>
> I have verified the links and Crystal says they are there, but
the
green
> "home plate" icon I was used to in V6-7 isn't there? I have
looked
at
> some of the default reports and that icon shows up. Do you
have it/
>
> John
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 7:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> John,
>
> I would look carefully at the links you used to the JobMtl
Table.
If
> you get no records after adding a field from that table I
would bet
> that its not properly linked. What fields are you linking on?
>
> JobOper.Company ->JobMtl.Company
> JobOper.JobNum ->JobMtl.JobNum
> JobOper.AssemblySeq ->JobMtl.AssemblySeq
> JobOper.OprSeq ->JobMtl.MtlSeq
>
> This should be the correct linking. As Dan mentioned, a left
join
> would give you all Job Operations whether or not there is a
> corresponding record in the Job Mtl Table. One other thought
that
> occurred to me while typing this, is that if you don't have a
related
> operation # in the Mtl Record, meaning the JobMtl.MtlSeq would
be
0,
> the above joins would return no records unless you made it a
left
> join.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Kathy Schmidt"
<kathyschmidt@f...>
> wrote:
> > Dan
> >
> > The only filters on the Job reports have been for closed
jobs or
> > completed line.
> >
> > For example, My Shop Forman wants to know what Jobs,
associated
> > operations, assemblies and material for that job are
remaining
> open. to
> > start, I create a blank report and attach the ODBC
database(s) of
> the
> > JobOper and JobMtl files. I then insert the jobnum file, the
index
> in
> > both files, the Seqnum and OperSeq from the JobOper file. I

select
> > records by JobClosed="false". That works. I add any field
from
the
> > JobMtl and re-run the query and get no records as a result.
> >
> > I've done this before (not on Progress databases) and can
get it
to
> > work, but I'm missing something simple. Vantage Product
Support
is
> > stumped and I have asked for their Crystal guru, but he
hasn't
> called
> > back.
> >
> > John,
> >
> > Are you using any report filters on either the main or the
> subreport?
> > What section of the main report did you place the subreport
into?
> Are
> > you linking the subreport to the main report? What are the
results
> that
> > your report returns? error messages?
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Wednesday, September 08, 2004 2:59 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > yes, the Progress ODBC drivers are installed and I am able
to
> access the
> > files one at a time. But I am unable to link files for
> Header/Detail
> > information.
> >
> >
> >
> >
> >
> >
> >
> > [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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
>
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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://groups.yahoo.com/group/vantage/links>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>

<http://us.ard.yahoo.com/SIG=129p196ji/M=298184.5285298.6392945.300117
6/D=gr
>

oups/S=1705007183:HM/EXP=1094823625/A=2319498/R=0/SIG=11thfntfp/*http:
//www.
> netflix.com/Default?mqso=60185352&partid=5285298> click here

>
> <http://us.adserver.yahoo.com/l?
M=298184.5285298.6392945.3001176/D=groups/S=
> :HM/A=2319498/rand=549766936>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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 Sponsor

<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=0/SIG=12iq6sl4l/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=10947402953
77944>
<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=1/SIG=12iq6sl4l/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=10947402953
77944>

Get unlimited calls to

U.S./Canada


<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1094
740295377944>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
s/S=:HM/A=2343726/rand=994732690>


________________________________

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-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
12
Great Point, I always turn the auto linking off, its more trouble
than its worth.

Brian

--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> The only point I would add in is to make sure the joins mentioned
are
> the only joins...
> If you let Crystal do it's default joining it will also connect the
VB
> fields Character01...Date01....
> These should not be joined and might cause the problem if they were.
> Just a thought.
> Also, when you see the join line, double click on the join to make
sure
> it's left outer.
> Hope this is of some help.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 10:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> Dan,
>
> Good point about it being necessary for assembly jobs, but I
> don't
> think this would cause him to get no records when adding the
> JobMtl
> table.
>
> Brian
>
> --- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...>
> wrote:
> > John,
> >
> > In thinking about this last night. Unless all your Jobs are
> only
> one level,
> > you might want to to try adding JobAsmbl
> > I would Join JobHead--- JobAsmbl, JobAsmbl to both Joboper
&
> JobMatl. This
> > should show job material releated to each job assembly,
> providiing
> > subassemblies were created as pull as assembly
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Thursday, September 09, 2004 8:37 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > Brian
> >
> > I have verified the links and Crystal says they are there,
but
> the
> green
> > "home plate" icon I was used to in V6-7 isn't there? I have
> looked
> at
> > some of the default reports and that icon shows up. Do you
> have it/
> >
> > John
> >
> > -----Original Message-----
> > From: Brian Stenglein [mailto:bstenglein@c...]
> > Sent: Thursday, September 09, 2004 7:52 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > John,
> >
> > I would look carefully at the links you used to the JobMtl
> Table.
> If
> > you get no records after adding a field from that table I
> would bet
> > that its not properly linked. What fields are you linking
on?
> >
> > JobOper.Company ->JobMtl.Company
> > JobOper.JobNum ->JobMtl.JobNum
> > JobOper.AssemblySeq ->JobMtl.AssemblySeq
> > JobOper.OprSeq ->JobMtl.MtlSeq
> >
> > This should be the correct linking. As Dan mentioned, a
left
> join
> > would give you all Job Operations whether or not there is a
> > corresponding record in the Job Mtl Table. One other
thought
> that
> > occurred to me while typing this, is that if you don't have
a
> related
> > operation # in the Mtl Record, meaning the JobMtl.MtlSeq
would
> be
> 0,
> > the above joins would return no records unless you made it a
> left
> > join.
> >
> > HTH,
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Kathy Schmidt"
> <kathyschmidt@f...>
> > wrote:
> > > Dan
> > >
> > > The only filters on the Job reports have been for closed
> jobs or
> > > completed line.
> > >
> > > For example, My Shop Forman wants to know what Jobs,
> associated
> > > operations, assemblies and material for that job are
> remaining
> > open. to
> > > start, I create a blank report and attach the ODBC
> database(s) of
> > the
> > > JobOper and JobMtl files. I then insert the jobnum file,
the
> index
> > in
> > > both files, the Seqnum and OperSeq from the JobOper
file. I
>
> select
> > > records by JobClosed="false". That works. I add any
field
> from
> the
> > > JobMtl and re-run the query and get no records as a
result.
> > >
> > > I've done this before (not on Progress databases) and can
> get it
> to
> > > work, but I'm missing something simple. Vantage Product
> Support
> is
> > > stumped and I have asked for their Crystal guru, but he
> hasn't
> > called
> > > back.
> > >
> > > John,
> > >
> > > Are you using any report filters on either the main or the
> > subreport?
> > > What section of the main report did you place the
subreport
> into?
> > Are
> > > you linking the subreport to the main report? What are the
> results
> > that
> > > your report returns? error messages?
> > >
> > > Dan Shallbetter
> > > States Electric Mfg.
> > >
> > >
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > > Sent: Wednesday, September 08, 2004 2:59 PM
> > > To: vantage@yahoogroups.com
> > > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> > >
> > >
> > > yes, the Progress ODBC drivers are installed and I am able
> to
> > access the
> > > files one at a time. But I am unable to link files for
> > Header/Detail
> > > information.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> > > Yahoo! Groups Links
> >
> >
> >
> >
> > 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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> > 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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
>
>
<http://us.ard.yahoo.com/SIG=129p196ji/M=298184.5285298.6392945.300117
> 6/D=gr
> >
>
>
oups/S=1705007183:HM/EXP=1094823625/A=2319498/R=0/SIG=11thfntfp/*http:
> //www.
> > netflix.com/Default?mqso=60185352&partid=5285298> click here
>
> >
> > <http://us.adserver.yahoo.com/l?
> M=298184.5285298.6392945.3001176/D=groups/S=
> > :HM/A=2319498/rand=549766936>
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> > <http://groups.yahoo.com/group/vantage/>
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> >
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of
> Service
> > <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> >
> > [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 Sponsor
>
>
<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.300117
6/
>
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=0/SIG=12iq6sl4l/*h
tt
>
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109474029
53
> 77944>
>
<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.300117
6/
>
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=1/SIG=12iq6sl4l/*h
tt
>
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109474029
53
> 77944>
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10
94
> 740295377944>
>
> <http://us.adserver.yahoo.com/l?
M=296572.5305651.6444487.3001176/D=group
> s/S=:HM/A=2343726/rand=994732690>
>
>
> ________________________________
>
> 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-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
13
me to.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, September 09, 2004 11:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Crystal Reports [bayes]


Great Point, I always turn the auto linking off, its more trouble
than its worth.

Brian

--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> The only point I would add in is to make sure the joins mentioned
are
> the only joins...
> If you let Crystal do it's default joining it will also connect the
VB
> fields Character01...Date01....
> These should not be joined and might cause the problem if they were.
> Just a thought.
> Also, when you see the join line, double click on the join to make
sure
> it's left outer.
> Hope this is of some help.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, September 09, 2004 10:31 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re:Crystal Reports [bayes]
>
>
> Dan,
>
> Good point about it being necessary for assembly jobs, but I
> don't
> think this would cause him to get no records when adding the
> JobMtl
> table.
>
> Brian
>
> --- In vantage@yahoogroups.com, Dan Shallbetter <dans@s...>
> wrote:
> > John,
> >
> > In thinking about this last night. Unless all your Jobs are
> only
> one level,
> > you might want to to try adding JobAsmbl
> > I would Join JobHead--- JobAsmbl, JobAsmbl to both Joboper
&
> JobMatl. This
> > should show job material releated to each job assembly,
> providiing
> > subassemblies were created as pull as assembly
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
> >
> > -----Original Message-----
> > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > Sent: Thursday, September 09, 2004 8:37 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > Brian
> >
> > I have verified the links and Crystal says they are there,
but
> the
> green
> > "home plate" icon I was used to in V6-7 isn't there? I have
> looked
> at
> > some of the default reports and that icon shows up. Do you
> have it/
> >
> > John
> >
> > -----Original Message-----
> > From: Brian Stenglein [mailto:bstenglein@c...]
> > Sent: Thursday, September 09, 2004 7:52 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re:Crystal Reports [bayes]
> >
> >
> > John,
> >
> > I would look carefully at the links you used to the JobMtl
> Table.
> If
> > you get no records after adding a field from that table I
> would bet
> > that its not properly linked. What fields are you linking
on?
> >
> > JobOper.Company ->JobMtl.Company
> > JobOper.JobNum ->JobMtl.JobNum
> > JobOper.AssemblySeq ->JobMtl.AssemblySeq
> > JobOper.OprSeq ->JobMtl.MtlSeq
> >
> > This should be the correct linking. As Dan mentioned, a
left
> join
> > would give you all Job Operations whether or not there is a
> > corresponding record in the Job Mtl Table. One other
thought
> that
> > occurred to me while typing this, is that if you don't have
a
> related
> > operation # in the Mtl Record, meaning the JobMtl.MtlSeq
would
> be
> 0,
> > the above joins would return no records unless you made it a
> left
> > join.
> >
> > HTH,
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Kathy Schmidt"
> <kathyschmidt@f...>
> > wrote:
> > > Dan
> > >
> > > The only filters on the Job reports have been for closed
> jobs or
> > > completed line.
> > >
> > > For example, My Shop Forman wants to know what Jobs,
> associated
> > > operations, assemblies and material for that job are
> remaining
> > open. to
> > > start, I create a blank report and attach the ODBC
> database(s) of
> > the
> > > JobOper and JobMtl files. I then insert the jobnum file,
the
> index
> > in
> > > both files, the Seqnum and OperSeq from the JobOper
file. I
>
> select
> > > records by JobClosed="false". That works. I add any
field
> from
> the
> > > JobMtl and re-run the query and get no records as a
result.
> > >
> > > I've done this before (not on Progress databases) and can
> get it
> to
> > > work, but I'm missing something simple. Vantage Product
> Support
> is
> > > stumped and I have asked for their Crystal guru, but he
> hasn't
> > called
> > > back.
> > >
> > > John,
> > >
> > > Are you using any report filters on either the main or the
> > subreport?
> > > What section of the main report did you place the
subreport
> into?
> > Are
> > > you linking the subreport to the main report? What are the
> results
> > that
> > > your report returns? error messages?
> > >
> > > Dan Shallbetter
> > > States Electric Mfg.
> > >
> > >
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Kathy Schmidt [mailto:kathyschmidt@f...]
> > > Sent: Wednesday, September 08, 2004 2:59 PM
> > > To: vantage@yahoogroups.com
> > > Subject: RE: [Vantage] Re:Crystal Reports [bayes]
> > >
> > >
> > > yes, the Progress ODBC drivers are installed and I am able
> to
> > access the
> > > files one at a time. But I am unable to link files for
> > Header/Detail
> > > information.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> > > Yahoo! Groups Links
> >
> >
> >
> >
> > 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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> > 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/.
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <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://groups.yahoo.com/group/vantage/links>
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
>
>
<http://us.ard.yahoo.com/SIG=129p196ji/M=298184.5285298.6392945.300117
> 6/D=gr
> >
>
>
oups/S=1705007183:HM/EXP=1094823625/A=2319498/R=0/SIG=11thfntfp/*http:
> //www.
> > netflix.com/Default?mqso=60185352&partid=5285298> click here
>
> >
> > <http://us.adserver.yahoo.com/l?
> M=298184.5285298.6392945.3001176/D=groups/S=
> > :HM/A=2319498/rand=549766936>
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> > <http://groups.yahoo.com/group/vantage/>
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> >
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of
> Service
> > <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> >
> > [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 Sponsor
>
>
<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.300117
6/
>
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=0/SIG=12iq6sl4l/*h
tt
>
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109474029
53
> 77944>
>
<http://us.ard.yahoo.com/SIG=1297vgpa7/M=296572.5305651.6444487.300117
6/
>
D=groups/S=1705007183:HM/EXP=1094826695/A=2343726/R=1/SIG=12iq6sl4l/*h
tt
>
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109474029
53
> 77944>
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10>
&time=10
94
> 740295377944>
>
> <http://us.adserver.yahoo.com/l?
M=296572.5305651.6444487.3001176/D=group
> s/S=:HM/A=2343726/rand=994732690>
>
>
> ________________________________
>
> 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-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129b15r64/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1094828661/A=2319498/R=0/SIG=11thfntfp/*http://www.
netflix.com/Default?mqso=60185352&partid=5285298> click here

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2319498/rand=773198479>


_____

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-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. 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@... 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.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this 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]
14
is the last link right JobOper.OprSeq ->JobMtl.MtlSeq? they really have no
relationship together.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, September 09, 2004 8:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Crystal Reports [bayes]


John,

I would look carefully at the links you used to the JobMtl Table. If
you get no records after adding a field from that table I would bet
that its not properly linked. What fields are you linking on?

JobOper.Company ->JobMtl.Company
JobOper.JobNum ->JobMtl.JobNum
JobOper.AssemblySeq ->JobMtl.AssemblySeq
JobOper.OprSeq ->JobMtl.MtlSeq

This should be the correct linking. As Dan mentioned, a left join
would give you all Job Operations whether or not there is a
corresponding record in the Job Mtl Table. One other thought that
occurred to me while typing this, is that if you don't have a related
operation # in the Mtl Record, meaning the JobMtl.MtlSeq would be 0,
the above joins would return no records unless you made it a left
join.

HTH,

Brian Stenglein
Clow Stamping Co.





--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> Dan
>
> The only filters on the Job reports have been for closed jobs or
> completed line.
>
> For example, My Shop Forman wants to know what Jobs, associated
> operations, assemblies and material for that job are remaining
open. to
> start, I create a blank report and attach the ODBC database(s) of
the
> JobOper and JobMtl files. I then insert the jobnum file, the index
in
> both files, the Seqnum and OperSeq from the JobOper file. I select
> records by JobClosed="false". That works. I add any field from the
> JobMtl and re-run the query and get no records as a result.
>
> I've done this before (not on Progress databases) and can get it to
> work, but I'm missing something simple. Vantage Product Support is
> stumped and I have asked for their Crystal guru, but he hasn't
called
> back.
>
> John,
>
> Are you using any report filters on either the main or the
subreport?
> What section of the main report did you place the subreport into?
Are
> you linking the subreport to the main report? What are the results
that
> your report returns? error messages?
>
> Dan Shallbetter
> States Electric Mfg.
>
>
>
>
>
>
> -----Original Message-----
> From: Kathy Schmidt [mailto:kathyschmidt@f...]
> Sent: Wednesday, September 08, 2004 2:59 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re:Crystal Reports [bayes]
>
>
> yes, the Progress ODBC drivers are installed and I am able to
access the
> files one at a time. But I am unable to link files for
Header/Detail
> information.
>
>
>
>
>
>
>
> [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



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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=1294vvtvj/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1094820751/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=762863764>


_____

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-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. 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@... 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.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this 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]