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

Click here to load this message in the networking platform