>>>>In the report make sure all fields don't have alias name in front of the fields and that Private DE is not checked.
>>>>
>>>>Also make sure your query returns records.
>>>
>>>
>>>Ok so what you're saying is everywhere I have gar_cur.firstname Delete gar_cur?
>>
>>Yes, remove the alias everywhere.
>>
>>>ALso where do I check the Private DE option didnt see it in the properties table
>>>and yes when I run the Query manually i get correct results
>>
>>In the Report menu make sure that Private DE is not checked and Printer Environment is not checked.
>
>
>So printer enviroment was checked so i went ahead and cleared it and removed the cursor name from the fields. and noww it doesnt find them...do i go ahead an put back the cursor name?

As Naomi said. Also make sure the query result cursor is selected and at top of file right before you issue the report command. Check the DE too (not just make it NOT private, but also is the DE of the report empty) or does it contain anything?