report based on SQL

[engnouna]

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

[binilmb]

You Can do like this

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

[binilmb]

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.

[engnouna]

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?

[binilmb]

Give "Cangrow" property to true and check