Thx, I will use the temp view option. Dan Goldberg
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, October 05, 2015 1:24 PM To: Dan Goldberg Subject: [RBASE-L] - Re: using where clause on sub report tables At 03:39 PM 10/5/2015, Dan Goldberg wrote: >I have a report with sub reports. I would like to filter out data in >one of the sub reports. > >I tried: > >Print reportname arrange subtable by column asc where subtable.column = >value > >But it says no correlation to the subtable name. > >Is there a way to filter data in a sub report table in a report or do I >have to do a view? FWIW ... When printing a report, Sub-Report(s)/Slave Table(s) records are contingent and/or relevant to Master table. Thus, no option to sub-select the data for Sub-Reports/Slave Tables. Pre-Defining the relevant data set based on a temporary view and then deriving your report on that specific view is your best option. Razzak
