<div>
Rather than doing it dynamically, try doing a LOV that is scheduled daily. Within the Business View Manager you can set up a LOV that will populate the entire list with what you are looking for. There are minimal reason to have dynamic LOV on company and location because they dont change that much in a day or week. Your business might be different but I have not run into a case. &nbsp;There are limits in the dynamic that will look at the first N rows, but I dont remember exactly where you have to modify it. 
</div>


<div>
Asker needs to respond to the expert comments.<br />
<br />
mlmcc
</div>


<div>
Was the solution of no help?
</div>


<div>
<div class="content wysiwyg-content">
I have a lot of reports that have Company and Location prompts. When I chose the Dynamic option and assigned the Company and Location fields to the Parameters, it does NOT return all the values. There are 35 Companies and 132 Locations; the Parameters just return 11 Companies and about 30 Locations. I am not sure how to solve this issue to get ALL values for Company and Location parameters. Therefore, I added Company and Location Stored Procedures to get ALL distinct values for Company and Location. Then, I assined the Dynamic option to the Parameter from this new Company and Location Stored Proc thinking it would return all values. But it gives me the error below - <br />
Prompting Failed with the following Error Message - &quot;List of Values Failure: fail to get values. [Cause of error - The length of parameter field current values must be less than or equal to the maximum value]&quot;<br />
Error Source: Prompt.dll Error Code: 0X8004380D
</div>
</div>


I have a lot of reports that have Company and Location prompts. When I chose the Dynamic option and assigned the Company and Location fields to the Parameters, it does NOT return all the values. There are 35 Companies and 132 Locations; the Parameters just return 11 Companies and about 30 Locations. I am not sure how to solve this issue to get ALL values for Company and Location parameters. Therefore, I added Company and Location Stored Procedures to get ALL distinct values for Company and Location. Then, I assined the Dynamic option to the Parameter from this new Company and Location Stored Proc thinking it would return all values. But it gives me the error below - 
Prompting Failed with the following Error Message - "List of Values Failure: fail to get values. [Cause of error - The length of parameter field current values must be less than or equal to the maximum value]"
Error Source: Prompt.dll Error Code: 0X8004380D

How to resolve the error  - List of Values Failure - Prompt.dll - Error Code 0X8004380D

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.