Walter Meester
HoogkarspelNetherlands
General information
Category:
ActiveX controls in VFP
Milicent,
>I have created a form to run a report that was designed in crystal. I am reporting from a VFP Table. I would like to be able to filter the data on a user defined criteria and then run the report for those results. My problem is allowing the crystal form to report from the particular cursor/table/view
I assume you're using ODBC to connect to the datasource, It might be handy to report of FPW2.x tables which are natively supported by CR. You can predetermine the data you want to report off and copy it to a Fox 2.x table.
COPY TO table FOX2X
You can use the datafiles property to change the location stored in the report:
CrystalReport1.DataFiles(0) = "c:\new\first.dbf"
CrystalReport1.DataFiles(2) = "c:\new\third.dbf"
Second, You can use the parameterfields property to pass values to the report:
CrystalReport1.ParameterFields(2) = "parameter3;blue;FALSE"
You should create them at forehand in you report.
Then you can filter your data with the help of this filter. Therefore you must have defined a record selection formula in your report (Report menu). You can use the defined parameterfield as a variable to filter on.
See the developers help to find more examples
BTW wich version are you using ?
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only