Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report flashing due to a query/cursor
Message
 
 
À
01/09/2010 13:51:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01479622
Message ID:
01479626
Vues:
41
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform