i would like to ask how to connect the crystal report with Visual Fox pro.
In connecting i mean the crystal report having to connect directly to visual fox pro .DBF without any coding on Visual Fox pro.
Is there any step like on how to connect stored procedures in SQL SERVER?
i know how to connect crystal reports to SQL SERVER, but i don't know how to connect crystal reports to visual fox pro .DBF
maybe this is a very simple question to you. kindly be understanding sirs. thanks in advance sirs and mams!
I've done this a few times, but it likely depends on your version of Crystal Reports.
In the more recent version,
in the Database Expert > Create New Connection > OLE DB(ADO) > Make New Connection
Now, on the screen that appears,
select Microsoft Jet 4.0 OLEDB Provider and click next
For the database name, you want the folder that the file resides in, NOT the whole path
. Finally,
select the table you want to use and proceed as you would with any other data source.