Sql query problem....

I've a datareport that uses dataenviroment to fetch data
the query i use is :

Code:

---

SELECT  * from testsdata,patient_ID as patientid, WHERE
    patientid = ?

---

here testsdata id the table , patient_id is the parameter i want to use as the filter.
But even when i supply the parameter using the code:

Code:

---

DataEnvironment1.Commands("report").Parameters(0).Value =txtPatientID

---

the report doesnt filter the data.... whatz gng wrong , any suggestions

try

Code:

---

DataEnvironment1.Report txtPatientID

---

This works on my reports