New Vantage User - Crystal Report Question

Yahoo Archive
1
You can not connect to Vantage by reading the database files as you will with MS Access or text files. You have to setup and use and ODBC connection. Epicor has a very helpfull ODBC kit they will be happy to send you.
Good luck,
Jeremy


-----Original Message-----
From: G M [mailto:gmccuen@...]
Sent: Tuesday, October 05, 2004 10:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] New Vantage User - Crystal Report Question




Hello everyone,

I am new to a company using Vantage, this is my first time with the
software.
I do have some experience with Crystal Reports so I have been asked
to get up to speed on writing Crystal Reports for Vantage data, and
become our local guru.

Here's my problem - after much searching I cannot find any database
files that Crystal is able to recognize! So where are they?

I know that each company's specific path to the DB's will be
different, but they should all be found in the same sub-
directories. So can someone please help point me there?
Also, if you can tell me what "type" of files I should tell Crystal
Reports to be looking for.

Thanks for the help,

Geoff McCuen







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
2
Hello everyone,

I am new to a company using Vantage, this is my first time with the
software.
I do have some experience with Crystal Reports so I have been asked
to get up to speed on writing Crystal Reports for Vantage data, and
become our local guru.

Here's my problem - after much searching I cannot find any database
files that Crystal is able to recognize! So where are they?

I know that each company's specific path to the DB's will be
different, but they should all be found in the same sub-
directories. So can someone please help point me there?
Also, if you can tell me what "type" of files I should tell Crystal
Reports to be looking for.

Thanks for the help,

Geoff McCuen
3
There are two ways to get at the data.
1. Using the .DBF files that get created by standard Vantage Crystal reports and located on the user's PC in the work directory. These are highly limied in fields available to use and require running the Vantage report first (at least to preview it).

2. Using ODBC to connect to the database. This is probably what you need. Do you have ODBC installed and running as a service on the server and connected to the database? If not check the Epicor site for the document for using ODBC. If you are using an older version of Vantage (like say 4.0) the ODBC programs and process will be a lot different than current versions using Progress 9.1d.

-Todd C.

-----Original Message-----
From: G M [mailto:gmccuen@...]
Sent: Tuesday, October 05, 2004 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] New Vantage User - Crystal Report Question



Hello everyone,

I am new to a company using Vantage, this is my first time with the
software.
I do have some experience with Crystal Reports so I have been asked
to get up to speed on writing Crystal Reports for Vantage data, and
become our local guru.

Here's my problem - after much searching I cannot find any database
files that Crystal is able to recognize! So where are they?

I know that each company's specific path to the DB's will be
different, but they should all be found in the same sub-
directories. So can someone please help point me there?
Also, if you can tell me what "type" of files I should tell Crystal
Reports to be looking for.

Thanks for the help,

Geoff McCuen






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=129g5h3e8/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1097073215/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=495707581>


_____

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]
4
There are actually two places that Crystal pulls from. When reports such as
Sales Order Acknowledgement, Purchase Orders etc are run Progress creates a
little data base in the Vntgwork folder on your C: drive to generate your
report. For building Crystal reports from scratch you need to have the ODBC
drivers installed and configured on your local machine and ODBC set up and
configured on your Vantage server.

Shirley Graver
Sys Admin
Rubber Associates Inc.

_____

From: G M [mailto:gmccuen@...]
Sent: Tuesday, October 05, 2004 10:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] New Vantage User - Crystal Report Question


Hello everyone,

I am new to a company using Vantage, this is my first time with the
software.
I do have some experience with Crystal Reports so I have been asked
to get up to speed on writing Crystal Reports for Vantage data, and
become our local guru.

Here's my problem - after much searching I cannot find any database
files that Crystal is able to recognize! So where are they?

I know that each company's specific path to the DB's will be
different, but they should all be found in the same sub-
directories. So can someone please help point me there?
Also, if you can tell me what "type" of files I should tell Crystal
Reports to be looking for.

Thanks for the help,

Geoff McCuen






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
(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=129g5h3e8/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1097073215/A=2128215/R=0/SIG=10se96mf6/*http:/compa
nion.yahoo.com> click here


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

_____

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/> .

Tracking #: 28D1A2E0AB38274DA25F41DE6EF118903613E080


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