Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I pass VFP objects as parameters to a crystal for
Message
From
10/03/2000 01:51:04
Walter Meester
HoogkarspelNetherlands
 
 
To
09/03/2000 17:07:47
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00343887
Message ID:
00344050
Views:
29
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
Map
View

Click here to load this message in the networking platform