Create Report on Visual basic

[bambang6]

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?

[karunakaran]

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

[bambang6]

Thanks Karun,

It's Work

I really appreciate

Tnaks Again
bambang

[bambang6]

Thanks Karun,

It's Work

I really appreciate

Tnaks Again
bambang