Clear vairables in child qvw document

[Anonymous]

I have parent.qvw file and child.qvw file.

In parent.qvw file there is button on click of it I am opening the child.qvw file.

In chlid.qvw file on load of the script, I have written

LET vCustomerid = Null;

LET vCustomerid= Input('Please Enter the Customerid', 'Customerid Input');

NoConcatenate

T2:

SQL SELECT * FROM Orders  where customerid='$(vCustomerid)';

When I run the child.qvw file alone, it ask(show popup window) to enter customerid.

But when I am opening from the click of button of parent.qvw file, it does not ask for customerid(it load the data which was at design time).

Please suggest.

[swuehl]

You could load all orders for all customers in your child qvw, then pass the customer id as selection when opening from parent QVW.

Or use Direct Discovery to query the DBMS on run time with a given customer id.

[Anonymous]

Any example/link how this can be done with Direct Discovery.

I want to load the orders details based on the customer id selected without loading the order details in memory.