Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Workbook with 3 queries

Hi All,

I have a workbook with 3 query results( 3 reports). Each query has got one variable and all the 3 conatains same variable (CalDay).

When I open the workbook only the variable for the last query is being executed and not the other two.

What I want to know is...since all the three queries contains same variable, is it possible to use single variable screen for all the

three queries in the workbook so that the user will enter the required date once and all the three

queries will be effected.

Please reply me ASAP as this is urgent...

Rgds,

James.

Former Member
replied

First try to set you curser in a cell outside a query and push the refresh button and answer yes to the question that all queries in the workbook are refreshed.

If this refreshes all you queries then you should do the following

Set the option in the workbook for each query that it should be executed when workbook opens.

Save the workbook.

I hope this helps

Best regards

Keld

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question