Passing Variables to Report

[jonnyk]

I have created a report connected to a command query in the data environment of my project. I wisg to filter the report based on a value on the calling form. I have placed a where clause on Sql statement of the command with a question mark. I have filled in the parameteres screen and call the report using the show method with the filtered value attached but all I get is a blank report
Any Ideas

 

[adnanakram]

use this if you use vb6 datareports
------------------------------------

on command button which show report
vname = txtname.text

DataEnvironment1.sprep vname
DataReport2.Show

-----------------------------------------
enter this query in datareport General tab
select * from tablename where name like [vname] order by name;

Now in parameter tab
--------------------
select Variant in datatype and host data type


in Coding of report add
-----------------------

Private Sub DataReport_Terminate()
DataEnvironmentname.datareportname.Close
End Sub

hope this thing work