>When I run my query and send it to a report and have a secreen preview, I don't get the results of my query in the report I get the whole database. What am I doing wrong.It seems that it is sending it to a temporary cursor instead. What can I do? This was a rather easy task in 2.6 why is it so hard in 3.0. Anyway thanks for all your help.

make sure the data environment in the report is empty, the cursor you built is selected, and that the report 'field' names don't have a table name in them...