How can I speed up a long list parameter LOV?
Hi,
I have a Purchase Order report with several parameters, some using LOVs and some not using LOVs. Overall, behavior is fine with both, except when the parameter LOV has a lot of values. For example, the Vendor LOV parameter list contains over 2000 values. When the user runs the report and wants to select a specific vendor from the list, the application is slow to deselect the All value, and can take 5+ minutes to select the single value from the list. This behavior only occurs when the list is large - another LOV driven parameter for Buyer is a
I have a Purchase Order report with several parameters, some using LOVs and some not using LOVs. Overall, behavior is fine with both, except when the parameter LOV has a lot of values. For example, the Vendor LOV parameter list contains over 2000 values. When the user runs the report and wants to select a specific vendor from the list, the application is slow to deselect the All value, and can take 5+ minutes to select the single value from the list. This behavior only occurs when the list is large - another LOV driven parameter for Buyer is a
0