>>>Hello!
>>>
>>>I made a normal report etc and did stuff like added my table.
>>>Then i made a cursor from a query named qry_gar.
>>>so i would run the query when i int the report the query does its querying adds it to a cursor named gar_cur.
>>>and i selected the cursor in my int of the report as well.
>>>
>>>Something like
>>>
>>>Do "Query"
>>>
>>>Select "Cursor"
>>>
>>>i get no errors untill i actually preview the report which is where it just blinks in and out. but when i delete the fields populated by my cursor an i comment out that code above. It works fine. Any idea what is causing this?or should i just add it to a table.
>>>
>>>Btw the fields on my report are populated by gar_cur.firstname etc
>>
>>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.
If it's not broken, fix it until it is.
My Blog