Order of the Merged Prompts with Multiple Queries

[Former Member]

Hi,

I have a WEBI XI 3.0 document that contains multiple queries.

One of the queries in the document has the following prompts in this order:

"Date:"

"Time:"

"Time zone:"

"Address:"

Another query in the document has the following prompts in this order:

"Date:"

"Time:"

"Name:"

"Address:"

If I do a Refresh All in the document, the prompts are merged and displayed in the following order:

"Date:"

"Time:"

"Time zone:"

"Address:"

"Name:"

However, I want "Address:" to be the last prompt displayed:

"Date:"

"Time:"

"Time zone:"

"Name:"

"Address:"

Is there a way to specify the order of the merged prompts?

[Former Member]

Hi,

To define the particular order of the prompts all the prompts should be at the universe level or at the report level.

As all the prompts defined at the universe level will appear first in alphabetical order and then the report level prompts will appear also sorted alphabetically.

In your case if possible create the prompt of Address at the report level and other prompts at the universe level it will automatically appear as the last one when you refresh all the queries.

Else you can change the prompt string to define the particular order.

@Prompt('1. Enter Date'.....)

@Prompt('2. Enter Time'.....)

@Prompt('3. Enter Time Zone....)

@Prompt('4. Enter Name'....)

@prompt('5. Enter Address'...)

Note: All the above prompts should be created either at the report level or universe level.

Regards,

Rohit

[former_member793810]

Hi Chih,

Suppose you have two queries and you have merged both the queries.

Now you want to add Prompt in Following Orders:

"Date:" (Query 1)

"Time:" (Query 2)

"Time zone:" (Query 2)

"Name:" (Query 1)

"Address:" (Query 2)

You will add the prompt Date for Query 1

You will add the prompt Time (Select Result from another query and select the Time)

Similar way you will add other prompts.

If you still want some modification then go to property and then change the order according to your need.

I hope this will resolve your issue.

Bashir Awan