I have to use Data Report which has to take input from the TextField which is embedded with VB form..

means i have to use a command in command object like this..

select * from TABLENAME where CUSTNAME = ?;

Can somebody help me..

How can I do this and what wiil be source of that?

Help needed urgently...

Thanks for any suggestion

DPK..

__________________
DPK..

hi deepu

write the same query in the Command object in the designer
and at te run time, pass the value for ur parameter

Dim de As New DataEnvironment1, rpt As New ReportName


If de.Connection1.State = 1 Then
  de.Connection1.Close
End If
de.Connection1.ConnectionString = "Write connectioun string here"
de.Connection1.Open

Set rpt.DataSource = de
de.CommandName
rpt.DataMember = "CommandName"
rpt.Show vbModal

de.Connection1.Close


i hope it will help

cheers

Ashu :)

oops...i forgot to pass the parameter

de.CommandName TextBox1.Text