General information
Category:
Reports & Report designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only