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