passing sql statements to data reports in vb6

i am trying to put some run time parameters into a data report. so the sql statement is being created out side the report, but the connection to the db is done within the report, how do i (a) pass the sql statement to the connection or (b) pass it straight to the report?

[SteveFlitIII]

You need to reference the data environment and the recordset name then you can pass in the parameters.

So when you want the report to be shown do the following

sub showreport

DataEnvironment1.Recordset "Parameter1", "parameter2", "parameter 3"

report.show

end sub

If you need any more just reply.