Ed,
Unfortunately, not yet. Because the SQL-92 asks for a Login each time (even with the workaround for the login that Epicor has supplied) Vantage bombs out on it. There is an open issue on this, and if you want to please add your name to it, it might lend some support to the cause.
Unfortunately, not yet. Because the SQL-92 asks for a Login each time (even with the workaround for the login that Epicor has supplied) Vantage bombs out on it. There is an open issue on this, and if you want to please add your name to it, it might lend some support to the cause.
----- Original Message -----
From: Ed Zywiec
To: 'vantage@yahoogroups.com'
Sent: Thursday, December 13, 2001 12:17 PM
Subject: RE: Re: [Vantage] Traveler tables
This might be my problem. We modified the Vantage 4.0 traveler so that the
ship releases would show in their proper order. We did this with a
subreport. We upgraded to 5.o and are using the new drivers (SQL-92). I
keep getting a cannot link error. Has anyone got a subreport to work with
the SQL-92 drivers. Call number is: #748545 ODBC and 599 error
"There has been more and more issues coming from in regarding ODBC and Crystal and the 599 error which appears to be ... stemming from the login to nested type of reports of crystal using the DSN. We are trying to find out info from Progress and Crystal. It appears that Crystal has no intentions of adding functionality automatic logins using a file DSN. And they are point to the Progress driver" -Jay Erickson
There are two workarounds that may work for you.
1. Use the Merant 3.5 or 3.6 drivers.
2. Export the table you need to a data file, link through Access, and then use a subreport as you have before.
Look up "Error 599" in the egroups messages and you'll get some history on this.
Troy Funte
Liberty Electronics
--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
After you Insert the Subreport and design it as desired (along with
it's new table).... Then you click Edit/Subreport Links. From here
you select the Formula field you created and make sure it is linked
to the correct field in the subreport.
I can send you a sample Purchase Order form that I modifed if you
need a live example.
You can do this via ODBC to live vantage tables if you are using
Merant 3.5 or 3.6, but there seems to be problems with the SQL-92
drivers when running a Vantage report in this way (even if it views
fine in Crystal Reports).
If you happen to be using the SQL-92 drivers, one way around this is
to export the table you need to a .dbf or .xls file and link through
Access.
Let me know if you have more questions.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Mark Dupuis
To: vantage@y...
Sent: Tuesday, November 27, 2001 9:44 AM
Subject: RE: [Vantage] Traveler tables
Hello Keith, Troy and Jim
Thanks for the info. Troy, I had the formula created but
couldn't figure
out how to link it to the real tables, Thanks for the Idea.
Mark Dupuis
-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@f...]
Sent: Tuesday, November 27, 2001 12:24 PM
To: vantage@y...
Subject: RE: [Vantage] Traveler tables
We are on 3.00.632 still and it is available for the job traveler.
The field
is jobship.PONUM we have in the page header for our traveler.
> -----Original Message-----
> From: dupuism@r... [mailto:dupuism@r...]
> Sent: Tuesday, November 27, 2001 10:51 AM
> To: vantage@y...
> Subject: [Vantage] Traveler tables
>
>
> Hello group, hope everyone had a good turkey day.
>
> I am trying to do something that I am sure would be ill
advised.
> I am frustrated with the choice of fields in the temp tables for
the
> job traveler. I need to have the customer PO on the traveler
along
> with the customer name. I decided to try adding tables to the
> report, linking them to the temp tables. I found that I am
limited
> to what fields I can link because many number fields in the real
> database are setup as text fields in the temp tables. I have been
> successful in linking the jobnum and extracting data from the
jobprod
> table but some of my other links seem to be hit or miss. Has any
one
> done this? I could use the user defined fields and make these a
> manual entry but it just bugs me when the info is already in the
> system.
>
> Thanks for any response
> Mark Dupuis
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[Non-text portions of this message have been removed]
--- End forwarded message ---
Yahoo! Groups Sponsor
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]