Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Embedding function in report
Message
 
 
À
12/07/2007 14:11:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01239800
Message ID:
01239823
Vues:
8
>>I have to edit a report that has one field with expression created by a function. Since function is in a procedure file, report runs very slowly.
>>How can I embed this function in the report?
>>
>>Thank you
>>
>>Ed
>
>>Why do you think the slowness is attributed to the fact, that your function >is in procedure file? Did you try with only this function in a procedure
>>(no more extra functions there)?
>
>This field expression was created with a sequence of embedded IIF statements. Several new conditions were added to this field and expression became too large and did not fit into expression size limit. I was forced to create a function and move it to a procedure file. Since this application actually is very old and has a lot of complex procedures inherited from FP-Dos, it's difficult to find and risky to change anything in codes.
>It's easy for me to create a cursor with report data, but it will go through a sophisticated chain of procedures with indexing and so on...
>
>Thanks
>
>Ed

Then just do pre-processing on your cursor instead. May be it would be quicker.
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