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

Error in workbook execution

Hi Experts,

I have created a workbook containing a view from three queries. All three queries have same selection screen.

The problem is when the workbook gets executed, the first two queries get executed bringing the correct values but the third does not get executed. I found that the values from the first query selection screen does not get passed to the third query selection screen.

I do not know how to overcome this. Kindly guide me.

With Kind Regards,

Shreeem

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 13, 2011 at 03:59 AM

    Hi,

    Just try following things

    1. Try to carry out refresh and global setting again.Just go to left corner and right click and check those setting and refresh again.Save work book again.

    2. If 1 is not successful just remove the third query and reinsert again ..Carry out refresh again.

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 08:50 PM

    Hi Shreem,

    What kind of a warning do you get? Like "no data available" ?

    Can you give some more details?

    Check the data providers of the design table by going to design mode and right clicking the table.By the way, I propose you to split the selection screens by unclicking "display double variables only once" by going to query properties in workbook.Then you will have different screens for each and can determine the problem easier.

    Regards,

    Güneş BÜYÜKTANIR

    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.