SAP Knowledge Base Article - Public

1218669 - Err Msg: "List of Values failure: fail to get values..." in Crystal Reports XI

Symptom

In Crystal Reports XI, when refreshing a report that uses a parameter with a dynamic and cascading prompt, the following error message appears:

"List of Values failure: fail to get values.[Cause of error: Type mismatch] prompt.dll Error code 0x8004380D"

Why does this error message appear and how do you resolve it?

Cause

This error message appears because in this scenario there are three levels of parameter, but the middle level parameter only contains null values.

For example, assume that you create a dynamic cascading parameter that uses the country, region and city fields. If you use a country that has no region values and only contains null values, this error message appears. Alternatively, if the country field has only null values, the error message also appears.

Resolution

To resolve this error message, ensure that every parameter level contains a value.

====================

NOTE:

This behavior is by design because using a field with all null values is not supported with dynamic and cascading prompts.

================================================================================

See Also

See the References Section for related Notes.

Keywords

DYNAMIC CASCADING PARAMETERS ERROR NULL PROMPT.DLL LIST OF VALUES FAILURE XI Crystal Reports Parameters Dynamic and Cascading Prompt , c2017298 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2