Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Embedding function in report
Message
From
12/07/2007 14:11:16
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01239800
Message ID:
01239820
Views:
7
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform