Problem in Data Report

[smita]

I am facing some problem in Displaying Data in dataReports:

i want to pass parameters from form to the data report query.

normally our query is select * from table_name

but ,
i want to pass query like

select * from table_name where condition1 and condtion2 etc....


now in condition1 and condition2 i want to pass some parameters or variables through vb form to report.

how do i ?
pls, explain with example and vb code?

[Lee Dale]

you will have to use an active data source on your report then from vb set the datasource of the report like

rpt.database.setdatasource = rst
as long as the recordset you are passing has the same structure as the active datasource in your report it will work