Need to resolve prompts urgently

[nimishabrahamc]

Hi,

I have a prompt which has numeric value but I want to display text in the prompt based on condition. When I run the report after selecting the prompt, I get this error.

Need to resolve prompts.
XQE-PLN-0097 Invalid format for numeric prompt 'XYZ'.

My Expression Definition Condition in the prompt is:

Case When [REPORT].[ABC] = '1' Then 'C'
when [REPORT].[ABC]  = '2' Then 'H'
when [REPORT].[ABC]  = '3' Then 'P'
Else '' End

Kindly please help me to resolve this.

Thanks,
acn

[cognos810]

Hello nac,
If I got your problem correctly, in your prompt query(query that feeds the values for the prompt UI), you should have two data items.
ONE, with the expression for the numeric i.e. [Report].[ABC] I believe.
TWO, with the expression as you have provided below:
Case When [REPORT].[ABC] = '1' Then 'C'
when [REPORT].[ABC]  = '2' Then 'H'
when [REPORT].[ABC]  = '3' Then 'P'
Else '' End

In the prompt UI you set the Use value to the data Item ONE and the Display value to data item TWO.

-Cognos810