>
>Russell,
>
>All of our application's reports are done with Crystal. Are you using the OCX control or the RDC component object model?
>
>Passing a var to Crystal isn't too difficult. The way I do it is to have a formula field set up in the report to receive the info from VFP. Then at runtime, I just use the proper method call (depending on the OCX or RDC) to populate the formula field.
>
>As for querying, I personally prefer to have CR do the query. I populate the query of the report with my own SQL statement against the VFP data. There are a couple of reports, however, where I need a data massaging routine first because CR itself would not be able to handle the calculations. In that case, I create the temp table and just replace the alias name of the table in the SQL statement.
>
>Let me know if you have any other questions.
>
>Jon
Russell,
I recommend doing everything with the RDC. The OCX is no longer being updated.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer