QE-DEF-0387 : Invalid format for numeric prompt

[yogeswari]

Hi All,

I am using prompt named "Month" and "Year"
Month prompt is having static choices:
UseValue      Display Value
ALL      ALL
1      1
2      2
3      3
4      4
5      5
6      6
7      7
8      8
9      9
10      10
11      11
12      12

Filter for the main query: [Month]=?pval_month? or 'ALL'=?pval_month?
When i choose ALL in prompt and run the report getting the below error:
"RQP-DEF-0354 The query contains one or more unresolved prompts.QE-DEF-0144 Prompt 'pss_wein' has no substitution values.QE-DEF-0387 Invalid format for numeric prompt"

This happens same to Year prompt.  But Year prompt contains values from Database.

Why this error is coming.  Please provide ur solutions and also suggest on this.



Thanks.

[Lynn]

What is the datatype for your month and year values in the database? If those are numeric than you would likely get an error trying to compare a number to a string.

You could try making the UseValue for All to be 0 and then adapt your filter expression accordingly.

[yogeswari]

Thanks lynn for your response.
Yes both are number datatype.  I changed the value of ALL to number and it work fine.
Thanks :)

Thanks,
Yogeswari.