Print Page - Prompt: default select top six countries

Title: Prompt: default select top six countries
Post by: Chandrasekar on 20 May 2014 12:55:40 AM

Hi All,
I want to develop a sales revenue report. In a prompt need to select country and default selection as top six revenue countries.

If it is possible to fix default selection in prompt. I am using relational model.

Please give me the suggestion.

Thanks & Regards,
CHANDRASEKAR

Title: Re: Prompt: default select top six countries
Post by: iceacman on 20 May 2014 05:13:04 AM

if your prompt is used to filter your query with revenue, then no.
if not , then possible, you will have to mix your prompt query with your revunue query, order the combined query by the rank of revenue

Title: Re: Prompt: default select top six countries
Post by: Chandrasekar on 20 May 2014 05:54:03 AM

Hi iceacman,

Thanks for your reply. I create two report pages then used java script. After i hide the dummy page. Now it works.

Regards
CHANDRASEKAR

Title: Re: Prompt: default select top six countries
Post by: iceacman on 20 May 2014 07:15:58 AM

good to know that you solved it
just wondering if it could be better to use two queries rather than two page+JS, LOL

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chandrasekar on 20 May 2014 12:55:40 AM