How do i select one row from many to print via crystal report?

[Pallex]

I have a crystal reports (6) control set up correctly in a VB 6 program. I pass it a report which is bound to a table in a database. So far so good.
What i want to do is select 1 row in the table and print that. At the moment i get a report for each row in the table.
I`ve tried setting the SQLQuery property to something sensible but it ignores me.
Does anyone know how to do this?

Thanks,
alex.