De Anna,
In regards to linking a new table with a eMfg Predesigned report in Crystal...
The issue there is that Vantage (er.. I mean eMfg.) exports special tables to your temporary (ie. c:\epic50) folder and runs the Sales Order Acknowledgment report off of those tables. ALL the fields in those tables have been converted to Text or String fields - unfortunately. The only way to link a NEW table into the report is via a subreport. And from then on, the report can only be run from a workstation with ODBC installed on it.
Here are the steps I use.
1. In the main report, create a formula to convert the linked field (like CustNum) to a number. Your formula might look like: "while printing records; (new line) tonumber({tablename.CustNum})"
2. Create the subreport with the Customer table in it.
3. Link the subreport Customer.CustNum to the Formula you created in Step 1.
4. Either put the subreport in the place on the report you want the Customer data to appear, or used the "shared variable" option to pass the data from the subreport to a variable in the main report.
Hope this helps. Let me know if you have more questions. I've successfully created the Purchase Order Form with an extra field from the PORel table this way.
Your other option is to pay Epicor Custom programming $700-$1,000 to have them add the fields you need to the exported dbase files and then they will be accessible from your report. (Plus pay them again each time you upgrade to the next version of eMfg.)
Troy Funte
Liberty Electronics
In regards to linking a new table with a eMfg Predesigned report in Crystal...
The issue there is that Vantage (er.. I mean eMfg.) exports special tables to your temporary (ie. c:\epic50) folder and runs the Sales Order Acknowledgment report off of those tables. ALL the fields in those tables have been converted to Text or String fields - unfortunately. The only way to link a NEW table into the report is via a subreport. And from then on, the report can only be run from a workstation with ODBC installed on it.
Here are the steps I use.
1. In the main report, create a formula to convert the linked field (like CustNum) to a number. Your formula might look like: "while printing records; (new line) tonumber({tablename.CustNum})"
2. Create the subreport with the Customer table in it.
3. Link the subreport Customer.CustNum to the Formula you created in Step 1.
4. Either put the subreport in the place on the report you want the Customer data to appear, or used the "shared variable" option to pass the data from the subreport to a variable in the main report.
Hope this helps. Let me know if you have more questions. I've successfully created the Purchase Order Form with an extra field from the PORel table this way.
Your other option is to pay Epicor Custom programming $700-$1,000 to have them add the fields you need to the exported dbase files and then they will be accessible from your report. (Plus pay them again each time you upgrade to the next version of eMfg.)
Troy Funte
Liberty Electronics
----- Original Message -----
From: De Anna Godfrey
To: Vantage
Sent: Friday, May 18, 2001 4:59 PM
Subject: [Vantage] Emfg, ODBC, and Crystal Reports
I installed Merant ODBC and I am able to connect and logon, but I get the
following error when I try to create reports for Emfg using Crystal Reports:
ODBC error: [Merant][ODBC PROGRESS driver]Optional feature not implemented
What is the optional feature? I would like to implement it!
Also, in the existing forms for Vantage, such as a Sales Order
Acknowledgement I have added the customer database to the report, but the
database will not link and it should. Any help would be appreciated.
Thanks,
De Anna Godfrey
V.P.
McNeal Enterprises, Inc.
408.922.7290 x14
fax 408.922.0728
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Yahoo! Website Services- Click Here!
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]