Print Page - "No data contents" for a prompt

Title: "No data contents" for a prompt
Post by: vovanenok on 15 Jun 2011 05:56:07 AM

Hi all, I have a prompt (check box group). The prompt values are populated by the query.
When this query doesn't return any data I want to display custom test like "No data available" instead of the empty prompt (without values).
I know that such option exists in data containers ("No data contents"), but how to realize it with prompt?

Many thanks in advance

Title: Re: "No data contents" for a prompt
Post by: kattaviz on 16 Jun 2011 09:57:49 AM

Hi,

You can use a variable to display "No data available" when the prompt query did not return any records.

HTH

Title: Re: "No data contents" for a prompt
Post by: vovanenok on 17 Jun 2011 03:53:05 AM

Thanks, but I found a better way (using combination of List and Prompt )

Title: Re: "No data contents" for a prompt
Post by: PRIT AMRIT on 17 Jun 2011 04:25:30 AM

QuoteThanks, but I found a better way (using combination of List and Prompt )

What's that? Would you mind to share the idea? It may help others having similar scenario?

Thanks

Title: Re: "No data contents" for a prompt
Post by: vovanenok on 17 Jun 2011 04:29:54 AM

The main idea is to place a prompt into the list column title, set the same query for this list as for your prompt and enable "No data contents" for your list.
As soon as I have some free time I will post this approach with screenshots.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: vovanenok on 15 Jun 2011 05:56:07 AM