PurAgent
Fredy Venczel
-----Original Message-----
From: Reilly, Rhonda [SMTP:rreilly@...]
Sent: Tuesday, February 10, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Buyer Table
Could someone tell me where the buyer table is? I can't be missing
something so obvious.
Rhonda Reilly
Information Resource Manager
American Aero / Titan
985.893.1818
985.893.1879 fax
-----Original Message-----
From: ehahn@... [mailto:ehahn@...]
Sent: Thursday, January 22, 2004 9:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem
Todd,
While you wait for the patch you can also click on the database menu
at the
top, and click on Visual Linking Expert. It will show the tables in
your
report with the joins between them. Click on one of the links, and
then
click on the link options button and change it to "left outer join".
Depending on how your report is set up you may need to do this for
more than
on (maybe even all) of the links you have. I don't have the patch
to fix
it, but doing this lets all the reports I have run fine.
Liz Hahn
Buyer
Guntert & Zimmerman
-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem
I recently implemented ODBC so I can use Crystal Reports with my
Vantage
database. Made a simple one table report and everything worked fine.
I
then started to create a report with some joins. The particular
report I
am creating contains the Customer table and the InvcDtl Table with
an
Outer Join on the Company and CustNum fields. When I run the report
I
get the following error:
ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The
keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.
Anyone know tell me what that means and how to work around it?
Thank for your help
Todd Hofert
IT Director
Spartan Graphics, Inc.
Fredy Venczel
-----Original Message-----
From: Reilly, Rhonda [SMTP:rreilly@...]
Sent: Tuesday, February 10, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Buyer Table
Could someone tell me where the buyer table is? I can't be missing
something so obvious.
Rhonda Reilly
Information Resource Manager
American Aero / Titan
985.893.1818
985.893.1879 fax
-----Original Message-----
From: ehahn@... [mailto:ehahn@...]
Sent: Thursday, January 22, 2004 9:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem
Todd,
While you wait for the patch you can also click on the database menu
at the
top, and click on Visual Linking Expert. It will show the tables in
your
report with the joins between them. Click on one of the links, and
then
click on the link options button and change it to "left outer join".
Depending on how your report is set up you may need to do this for
more than
on (maybe even all) of the links you have. I don't have the patch
to fix
it, but doing this lets all the reports I have run fine.
Liz Hahn
Buyer
Guntert & Zimmerman
-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem
I recently implemented ODBC so I can use Crystal Reports with my
Vantage
database. Made a simple one table report and everything worked fine.
I
then started to create a report with some joins. The particular
report I
am creating contains the Customer table and the InvcDtl Table with
an
Outer Join on the Company and CustNum fields. When I run the report
I
get the following error:
ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The
keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.
Anyone know tell me what that means and how to work around it?
Thank for your help
Todd Hofert
IT Director
Spartan Graphics, Inc.