Print Page - Getting error "QE-DEF-0387 Invalid format for numeric prompt"

Title: Getting error "QE-DEF-0387 Invalid format for numeric prompt"
Post by: cat23 on 15 Jan 2019 05:33:34 PM

Hello.
I am new here. I need a help with a prompt that gives me an error when I run and leave empty field.
My filter is "[REMAINUSAGE] < ?SEL_LEASTUSAGE?"
RemainUsage is a calculate field (Field 1 - Field 2)
When I run the report and add the value in SEL_LEASTUSAGE prompt it is running fine.but I need to have empty field or add % to retrieve all data, i have the error.

I have tried add in filter: [REMAINUSAGE] < ?SEL_LEASTUSAGE? or ?SEL_LEASTUSAGE? IS NULL same error

I don't know where I can add the data type = numeric or change it to string
thank you

Title: Re: Getting error "QE-DEF-0387 Invalid format for numeric prompt"
Post by: Andrei I on 15 Jan 2019 06:47:42 PM

Did you try to make your filter "Optinal" ?

Title: Re: Getting error "QE-DEF-0387 Invalid format for numeric prompt"
Post by: MFGF on 08 Feb 2019 08:07:02 AM

Hi,

How about using a prompt macro with a default value of 0 specified, eg

[REMAINUSAGE] < #prompt('SEL_LEASTUSAGE', 'integer', '0')#

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cat23 on 15 Jan 2019 05:33:34 PM