How do you dynamically select records in the MS Data Environment?

[SirPaladin]

Since Microsoft has made VB 6.0 incompatible with the Crystal Reports they shipped in version 5.0, I have to redesign my report using the Microsoft Data Report, for which you have to access through the Microsoft Data Environment. The only thing I haven't been able to figure out is how to dynamically limit the records included in the report to those I indicate in a complex SQL statement. It looks like the only queries I can create within that Data Environment have to be hard coded. That's useless to me.