Skip to Content
author's profile photo Former Member
Former Member

Pass filter values from one query to another in a workbook, AFTER RUNTIME

Hello

I have a workbook which has 5 different queries. I have a main query, and the other queries are controlled in a way by the main query: I created replacement path variables for the other queries, to pick documents from the main query.

The workbook works well at runtime. But after the qorkbook runds, if I filter on a few documents in the main query.. the other queries do not reflect this change. Is there a way where I can pass this information from the query to another in the workbook. So that, when the user plays with fliters in the main query after run time.. he can see the values change in the subsequent queries.

Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2010 at 04:09 AM

    Hi,

    You need to refesh dependent queries as chaning main query will only refersh the same not the dependent ones.

    So if you refersh the dependent queries after modifying/filtering main then those would respect the changes.

    I hope it will help.

    Thanks,

    S

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I dont see a 'REFRESH' option in the context menu (when I right click on the query). Also, the REFRESH option available in the MENU options (ie PAUSE AUTOMATIC REFRESH) also does not work.

      The way I built my workbook was, I built the 1st query in Analyzer and then I started inserting 'ANALYSIS GRIDS' in the remaining worksheets. To these GRIDS - I linked a data provider and linked a query or query view to that data provider.

      Any more suggestions??

      Regards.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2010 at 03:37 PM

    I tried an option of inserting a 'Navigation Pane' in the workboook. But it can only affect 1 data provider. Cant I use a nav pane which can affect all the data providers or queries in my report?

    Or is there another way... using a MACRO for ex??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2010 at 12:39 PM

    Any suggestions guyz??

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.