Bob The only way I know is to do report from temp tables that is in accordance with your selection.
There might be other ways I am not aware of!? Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 16 december 2008 18:19 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SubReport selection 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
