Skip to Content
0
Oct 21, 2005 at 09:41 AM

Order of Variables when using a pre-query (Web)

36 Views

Hi,

I have an issue concerning the order/sequence of variables in the variable screen of a webreport.

Here is the situation:

I have 2 queries in 1 webtemplate. For both queries I use a pre-query to fill the same variable in these two queries plus there is another variable (the same one) which is used in the 2 target queries.

Pre-Query:

Variable 1: Valid from

Variable 2: Valid to

Output for the other reports: 0MATERIAL

Query 1:

Variable 1: 0MATERIAL (filled from the pre-query)

Variable 2: variable on 0CALWEEK

Query 2:

Variable 1: 0MATERIAL (filled from the pre-query)

Variable 2: variable on 0CALWEEK

The variable pop-up in the browser shows the following

order

1. Valid from

2. 0CALWEEK

3. Valid to

The order should be:

1. Valid from

2. 0CALWEEK

3. Valid to

How can this be done?

The problem is, that I cannot change the order within one of the queries, because no query contains ALL variables and I don't see the rule the variable pop-up uses to arrange the variables.

TIA

Regards,

Guido