Passing Parameters to report with no popup

[Guest_imported]

I am using selection formulas to draw data from an access database. I would like to add a parameter to the selection formula in the form of a where clause, But I do not want to issue a popup to the user. I would like to set the parameter programatically. I am using VisualC++ and the RDC. Is this possible?

I am currently limiting my resultset with a formula, but that takes to long, as the entire database is grabbed before the formula is run against the data to limit the results for the report. A where clause would greatly speed things up for me as my datasets are huge.

 

[goose98]

I've got the same pb with VC++.
I use the CDO lib.
I can open a report, open a preview windows, send data from a rowset, but i can't send a parameter value.
So if U receive a solution .... please
dubourg.vincent@libertysurf.fr

good luck

 

[chelseatech]

I've found some examples where it was more efficient to pass to CR the entire record selection with
crObj.RecordSelectionFormula =
"{client.id} in ['1','2','7', '12']"

http://www.chelseatech.co.nz

Editor of Crystal Clear