Data Report Problem

[darrel]

Question: How can i add runtime parameter using DATA REPORT in vb6?
For example: i want to show the record of a specific customer
personal information only.

e.g.
"SELECT * FROM CustomerInfo WHERE CustomerName = ' " & txtName.text & " ' "


Any ideas will be a great help for my system... Thank you...

[muddasirmunir]

you can done it by closing the current recordset and then open
it by using your deisired query in the initialized evnet of the datareport.

Question: How can i add runtime parameter using DATA REPORT in vb6?
For example: i want to show the record of a specific customer
personal information only.

e.g.
"SELECT * FROM CustomerInfo WHERE CustomerName = ' " & txtName.text & " ' "


Any ideas will be a great help for my system... Thank you...

[QVeen72]

Hi,

Add a Parameter for your command Text say :

"SELECT * FROM CustomerInfo WHERE CustomerName = ? "

And before Showing the report, Pass the parameter:
DataEnvironment1.Command1 txtName.text

If it dosent work try this :
DataEnvironment1.Command1 "'" & txtName.text & "'"


Regards
Veena