Base DataReports on dynamic queries

[Asterisk]

How do i create a report using VB6 new Data Reporting tool, But i want to create Query statements at runtime and then base the reports on these queries. I have been able to create the reports when the queries are defined at design time but have not been successful when trying to use dynamic queries. Can anyone help me? Thanks

[Oliver]

Hint: use the commandtext property of the command object within the commands collection