How to get One Selection Screen for all queries?

[Former Member]

Hi Experts,

I have three queries having selection screens. All the selection screen have the same variables, but the reports are different.

I have created a workbook having these three queries. Each time when the workbook opens, the three selection screen pops up one after the another. Same values are entered in all the selection screens.

Now the user wants only one selection screen for all the three reports. Is it possible? I tried but I do not see any way.

I think there should be some way of getting it done.

Waiting for your inputs,

With kind regards,

Shreeem

[Former Member]

Hi

If a workbook contains multiple queries that use the same variable, you are prompted to enter the variable values again for each query. To avoid this, set the Display Duplicate Variables Only Once flag.

Goto Workbook Settings>Under Variables Tab>select Display Duplicate Variables only Once

http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/54/a493f7256b43698191a2623e5a0532/frameset.htm

Hope this helps,

Aparna Duvvuri

[former_member182343]

Hi Shreem,

Better remove 2 variable of same from 2 queries and enable one variable which is same for all queries, then you will get one variable screen to popup input desired.

Regards,

rvc