Create Report on Visual basic

I tried to make report using Datareport in VB. For this purpose I use dataenvironment|Connection1|command1 as datasource.
To get the specific record I used the following statement on the SQL Statement on Command1 properties.

SELECT * FROM expatdata WHERE firsname = '" & documentstatus.text.text1 & "'

This statement I used to get record where firstname same with firstname on the documentstaus Form. But this statement just gave me the blank report.

Anyone can help me?

Hi,
All other things what you did is correct.
In the SQL you change like this.
SELECT * FROM expatdata WHERE firsname = ?

Then go to the parameters tab and set the properties.

open this command where you want to open the report with the parameter.

Dataenvironmet.command (parameter)
datareport.show


thanks
karun

Thanks Karun,

It's Work

I really appreciate

Tnaks Again
bambang

Thanks Karun,

It's Work

I really appreciate

Tnaks Again
bambang