Joining DBF and ODBC

Yahoo Archive
1
Create a subreport with the odbc database, and link the subreport using the
exported DBF files.
You may need to convert the fields in the DBF file to a number to join, and
therefore create the join using the calculated field to the subreport.
You are correct. You can't join directly to the DBF, but the subreport
trick will allow it and I have used this method several times.
You also have to set up all your clients with ODBC, and set up the .mfg file
to enable the odbc parameters at it's end.
Let me know if you need details.
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Friday, January 21, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Joining DBF and ODBC




Has anyone sucessfully joined the a DBF with an ODBC database?

Epicor uses the DBF files in the c:\epicor\mfgwrk61 folder for its
normal reports in the system such as the Sales Order and Traveller
etc.

I want to add fields to this, but when I try to link the ODBC
database on the server to this, I cannot produce the results.

Has anyone solved this?

Thanks!
Ben





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
Has anyone sucessfully joined the a DBF with an ODBC database?

Epicor uses the DBF files in the c:\epicor\mfgwrk61 folder for its
normal reports in the system such as the Sales Order and Traveller
etc.

I want to add fields to this, but when I try to link the ODBC
database on the server to this, I cannot produce the results.

Has anyone solved this?

Thanks!
Ben