Dynamic Load Statements

[#1]

Is there a way to make the Load Statement dynamic so that the dataset pulled for the QVW is only the records the user wants?

We have two normalized tables that, once denormalized, grows to a set of over 6 million rows.  The user wants to report on these data; but wants to choose which records based on criteria in the original tables.

An example:

Table A  (50 total rows)

     DefID                       1,2,3,4

     DefName                  Pots, Pans, StoreNumber, Status

     DefType                    Char, Char, Num, Bool

     DefSequence             17,1,5,30

Table B (6 mil + rows)

     DefID                     1,1,2,4,3

     CustID                   1001,1002,1003,1004,1004

     DefValue                Copper,Brass,FlatIron,0,27

DeNorm Table

A.DefID,A.DefName,A.DefType,A.DefSequence,B.DefID,B.CustID,B.DefValue

1,Pots,Char,17,1,1001,Copper

1,Pots,Char,17,1,1002,Brass

2,Pans,Char,1,1003,FlatIron

4,Status,Bool,30,1004,0

3,StoreNumber,Num,5,1004,27

A common report would be to give all the Pots for Customer 1004; or All Customers with FlatIron Pans.

What we need is to ask the Load statement to only load those records with the A.DefName(s) = [var] , or B.CustID(s) = [var] or, A.DefNames for B.CustID(s).

Is this possible?

I am relatively new to QV and come from a Crystal Reports background where I would have a paramterized Select statements that ask for parameters first;

then use those selections in the record select; but I am not sure how to accomplish this in QV.

I have looked at posts by

John Witherspoon or Greg Hood; but cannot find anything addressing this specific type of action.

[rwunderlich]

An approach to the database resource issue is to implement incremental (delta) loads where you select only the new & updated rows and merge with a qvd file.

-Rob