If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

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

Started by Sarayucog, 15 Dec 2011 10:40:21 PM

Previous topic - Next topic

Sarayucog

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.

HalfBloodPrince

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