Russ,
I have done this two ways: 1. Export from Utilities/Export in Vantage to an Ascii or Excel file, then set up an Access file from those exports, or 2. Export using a Progress .p program to a .csv file, then set up an Access file from those exports. I strongly prefer option #2 now that I have figured out how to do it because you can easily set up the Task Scheduler to do the exports each night, and they are much more 'configurable' in my experience.
It really helps if you also export the field names so that Access imports those names for you.
Once you have the exported files, however, here is what you do.
--In Access:
1. Open a new database.
2. Select File/Get External Data/Link Tables...
3. Change File Type to Text Files (.txt, .csv, etc) and then go find your exported file.
4. Walk through the Linking wizard to import the text file, along with headers. Do Steps 2 through 4 for each Table that you have exported.
5. Create a new Query by using the query wizard. Select the table you just made in Step 4, include each of the fields, and give it a name. Do this for each Table that you linked in Step 4 above.
--In Crystal:
1. Open a new blank report.
2. Go to the DATA Explorer.
3. Select ODBC.
4. Select MS Access Database
5. Browse to the Access Database you created above.
6. Select that database.
7. You should see the query(s) that you made above. Select it (them) and click ADD. Do this for as many querys in the Access Database as you want. I usually make one Query for each Table that I have exported.
8. Now you can go to your Visual Linking Expert and Link the Queries (now called Tables in Crystal) if needed.
9. If you exported your Field names properly, you should be able to see them in Crystal and you can do your report.
Troy Funte
Liberty Electronics
I have done this two ways: 1. Export from Utilities/Export in Vantage to an Ascii or Excel file, then set up an Access file from those exports, or 2. Export using a Progress .p program to a .csv file, then set up an Access file from those exports. I strongly prefer option #2 now that I have figured out how to do it because you can easily set up the Task Scheduler to do the exports each night, and they are much more 'configurable' in my experience.
It really helps if you also export the field names so that Access imports those names for you.
Once you have the exported files, however, here is what you do.
--In Access:
1. Open a new database.
2. Select File/Get External Data/Link Tables...
3. Change File Type to Text Files (.txt, .csv, etc) and then go find your exported file.
4. Walk through the Linking wizard to import the text file, along with headers. Do Steps 2 through 4 for each Table that you have exported.
5. Create a new Query by using the query wizard. Select the table you just made in Step 4, include each of the fields, and give it a name. Do this for each Table that you linked in Step 4 above.
--In Crystal:
1. Open a new blank report.
2. Go to the DATA Explorer.
3. Select ODBC.
4. Select MS Access Database
5. Browse to the Access Database you created above.
6. Select that database.
7. You should see the query(s) that you made above. Select it (them) and click ADD. Do this for as many querys in the Access Database as you want. I usually make one Query for each Table that I have exported.
8. Now you can go to your Visual Linking Expert and Link the Queries (now called Tables in Crystal) if needed.
9. If you exported your Field names properly, you should be able to see them in Crystal and you can do your report.
Troy Funte
Liberty Electronics
----- Original Message -----
From: silvey3279@...
To: vantage@yahoogroups.com
Sent: Thursday, July 18, 2002 11:47 AM
Subject: [Vantage] Re: UOM on Inventory Tags
The goal is to get the UOM on the tags. I have heard some people exporting from the Utilites menu to an Access Data Base
and Linking with ODBC on the Crystal Report. I really dont have any preference how the GOAL is obtained. If it can be done by modifiying the Crystal Report, that would be accecptable also.
Russ Silvey
Wisdom Industries
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]