Print Page - Is it possible to give the static choices as Number and Char

Title: Is it possible to give the static choices as Number and Char
Post by: Sarayucog on 15 Dec 2011 10:40:21 PM

Hi All,

I have a value prompt (Single select) with static choices like 10, 20, 30 and ALL. Based on the selection it should display number of records. If select ALL it should display all records, but if I am giving static choices like this its giving an error like

RQP-DEF-0354 The query contains one or more unresolved prompts.
QE-DEF-0387 Invalid format for numeric prompt 'Parameter1'.

How to achieve this pls let me know the solution.

Thanks in advance.

Title: Re: Is it possible to give the static choices as Number and Char
Post by: HalfBloodPrince on 15 Dec 2011 11:01:47 PM

try this
in filter use cast(?parameter? , integer) instead of ?parameter?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sarayucog on 15 Dec 2011 10:40:21 PM