Subject Two table filter in report
From Charlie <tm@tc.com>
Date Mon, 24 Apr 2017 05:31:45 -0400
Newsgroups dbase.getting-started

Hi.. I have a report with two tables in it.  I can easily filter one of the tables which happens to be in the detail but the table in the header I cannot seem to figure out how to include that in the filter.  Here is the code.  The last line is me grasping at straws to try to get this to work.  BTW both tables have the same field that I am trying to filter on:

      filt = form.golfers_scores1.rowset.fields["dbname"].value
                set procedure to test.rep
                form.oRep = new testreport()
                form.oRep.streamsource1.rowset.filter := [dbname=']+ filt+[']
                form.oRep.reportgroup.headerband.filter := [dbname=']+ filt+[']

Thanks for any help!!