Using Visual FoxPro Tables In Crystal Reports 1

[LeonelSanchezJr]

I've never used Visual FoxPro tables in Crystal reports. I know how to add the table, but I don't know how to use the parameters to filter my data or "select" from the table as I normally do using SQL 2000 Stored Procedures.

 

[lfaustino]

Hi there,

There's two ways of doing it.
First is by using native dbf, when you create the report you assing it a dbf Fox 2.6 type. Then, from within yot Foxpro code, you issue a select where you can gather information for all the tables you want and export it to a .dbf Type 2.6 file, and use this command to define the source for the report :

CRReport.CRApplication.OpenReport("datafile.dbf&quot
The other way is by creating the report using odbc and defining all the linking within the report, the from the VFP code, just assign values to parameters that you previously defined within the report, for more info on this I advise you to see another thread that I posted about this on this form.

Hope this helps.