report based on SQL

Hi
I have a form that contains a command "Generate Report",the report is based on a query,but the problem is that depending on the users' entries,the query changes, so before generating the report, the program should take the SQL statement and then generating the report using the Data report that comes with VB6.
I tried using the stored procedures but it didn't work
is that another solution
thanks

You Can do like this

VB Code:

If DEnvir.rsCommand1.State = 1 Then DEnvir.rsCommand1.Close
            DEnvir.rsCommand1.Open [Your Sql Statement here]
            Report1.Show

And

Give Sql Statement in the Command as

"Select * from Tablename"

when calling the report using user entries

you query will be


"Select * from Tablename where fieldname='value'"

that means the fields in the sql of command and ur sql should match.

thanks binilmb

but when i run my code the following message appears:
Error wrapping lines of text in control 'Label1'

I know this is a report design error but what's the origin of this error?

Give "Cangrow" property to true and check