Report record source

[John]

Hi

Is it possible to change the record source query of a report at runtime via
code so the report can work with different data source queries?

Thanks

Regards

 

[Douglas J. Steele]

Sure. In the report's Open event, set its RowSource to whatever you want.

 

[John]

If I am opening the report using OpenReport, how can I pass it the name of
query to open in Open event?

Thanks

Regards

 

[Jamey Shuemaker]

if you're running A2K2 or later, you can use OpenArgs. otherwise you'll
have to monkey around with the 3rd and 4th arguments of the OpenReport
method (FilterName and WhereCondition).

 

[John]

I am using a2k. Any example of using FilterName or WhereCondition for this
purpose?

Thanks

Regards

 

[UpRider]

I handle this by setting the report's record source to qtempQuery and then
creating the appropriate qtempQuery just before opening the report.

HTH,
UpRider

 

[Douglas J Steele]

Neither FilterName nor WhereCondition would be appropriate for that.

You could use UpRider's suggestion, or you could use a global variable that
you use in the Open event.