Print Page - QE-DEF-0387 : Invalid format for numeric prompt

Title: QE-DEF-0387 : Invalid format for numeric prompt
Post by: yogeswari on 10 Oct 2014 01:01:19 AM

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.

Title: Re: QE-DEF-0387 : Invalid format for numeric prompt
Post by: Lynn on 10 Oct 2014 04:59:02 AM

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.

Title: Re: QE-DEF-0387 : Invalid format for numeric prompt
Post by: yogeswari on 13 Oct 2014 01:57:15 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: yogeswari on 10 Oct 2014 01:01:19 AM