Selecting recordset for DataReport at runtime

[MaryKJolly]

I want to create a Data Report in my project. I have created a Data Environment and connect my database to it. I want to select a recordset at runtime and display as the report. So in the 'Command1 Properties' I have created an SQL Statement as the 'Sourse of Data'.I want to give a variable in that SQL Statement. eg. select * from MARK where AdmissionNo=<ad mno>. (I want to create the Report for the Mark details of a particular student whose Admission No which will be given at the runtime).I have defined the variable 'admno' globally in a code module.Can I do this?

[debasisdas]

you ned to frame the query at runtime and pass to datareport.