COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kevvukeka on 22 Jan 2013 09:12:00 AM

Title: How to reorder prompts in report studio
Post by: Kevvukeka on 22 Jan 2013 09:12:00 AM
I have 3 prompts in a prompt page
The order in which I want the prompts to appear is:Sales Territory,Country,Staff Name.
But the order in which appear are:Country,StaffName,Sales territory.

How can I reorder them?

Thanks for your help.
Title: Re: How to reorder prompts in report studio
Post by: bi4u2 on 22 Jan 2013 02:05:19 PM
It sounds like you do not have a prompt page that you created, but you have some parameterized filters on your query. You can try reordering the filters on your query.
Title: Re: How to reorder prompts in report studio
Post by: Kevvukeka on 23 Jan 2013 02:44:25 AM
I created a Prompt page and inserted 3 value prompts in an order that I need, but when I run the report the prompts still display in alphabetical order. All these prompts were related to same query.

Now I created the same prompts using different query for each prompt, now the prompts display in the order that i created not in alphabetical order.

So when we are creating prompts based on 1 query,dont we have the option of reordering the prompts??
Title: Re: How to reorder prompts in report studio
Post by: absriram on 28 Jan 2013 05:19:17 PM
The prompts in a prompt page should appear exactly as you place them. Alphabetical sorting of prompts happen only in case of auto generated prompts.

Make sure the parameter names of the prompts in the prompt page match the parameters you use in the filter. If they don't, then auto generated prompts will appear.

Sriram.
http://www.cognosonsteroids.com (http://www.cognosonsteroids.com)