I have a report with a sub report. So far so good... However, I want to limit the selection criteria in the sub report. i.e.
Main table has column MO_Number sub report table has column MO_Number When I print the report, the sub report prints all records for the matching MO_Number as expected. I now want to narrow the records in the subreport to only include the MO_Number with a specific date. Sub table has a column MO_Date in it, but the driving table does not. I did not see in the FTE article how to narrow the selection in the subtable. I tried creating a single table view of the subtable that contained only the data I wanted to include, but the report only printed (1) record for some reason. 1)Is there syntax for a where clause on the report subtable? 2)If not, what is the proper method for imitiating the where clause. Thanks, -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441
