Print Page - Value prompt returning empty values

Title: Value prompt returning empty values
Post by: barrysaab on 24 Sep 2011 05:25:41 AM

My Report is list report in which there are 200 categories items and i want to restric user to less than 15 items only.This report is built through SQL query,so i have defined prompt in sql query itself using #prompt many function and have dragged value prompt on the prompt page and choose existing parameter.But when i run the report there are no values coming up in value prompt.where as when i slect packaged item,it is showing value.Is any way around,Please Help.Thanks

Title: Re: Value prompt returning empty values
Post by: blom0344 on 24 Sep 2011 03:18:56 PM

This usually happens when one forgets to associate a use and display value with the prompt (in properties)

Title: Re: Value prompt returning empty values
Post by: barrysaab on 25 Sep 2011 10:29:37 AM

I did defined the use value and display value but still it shows no data.Thanks

Title: Re: Value prompt returning empty values
Post by: blom0344 on 25 Sep 2011 03:05:30 PM

No output when you run the prompt query as tabular data?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 24 Sep 2011 05:25:41 AM