>>>>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?

No. If you want your report to run from the query results, you need to have all the fields in that query.