At 03:32 PM 5/27/2009, Bill Niehaus wrote:
Is there a way to select records that print based upon the table
in the main report as well as the table in the sub report?
I can get records from the main table by using a condition in a
WHERE clause, but don't know how to select based upon columns in
the sub report.
Bill,
Technically, sub-set of master records (used as sub-report) are
the matching records from slave table. In a situation like this,
WHERE clause is applicable to the main table only.
-- Example
PRINT CustomerContacts +
ARRANGE Contact BY ContLName,ContFName +
ORDER BY Company WHERE CustState = 'CA' +
OPTION SCREEN|WINDOW_STATE MAXIMIZED +
|ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90
RETURN
Having said that, if you still need to limit the records for
slave table(s), you will need to do that up-front using the
TEMPORARY table(s) on the fly, with only the records you want
and then base the sub-report part on that temporary table to
achieve your goal.
Hope that helps!
Very Best R:egards,
Razzak.
