Filtering subreports

[JohnnyFalcon]

Hi All,

I have a report which contains a subreport. The subreport returns a
complete list of Career History information for all employees.

When the report opens, it only opens for a single Employee, and the
subreport opens containing correctly all the Career History for that
Employee.

Is it possible to filter this list to only return the top 10 rows of
Career History?

I originally tried adding a TOP 10 command to the SQL but this seemed
to apply the filter to the returned rows before applying the Employee
ID match in the subreport, therefore returning 10 rows of data for the
first record but nothing for any other records.

Any help gratefully appreciated.



Regards
Johnny

 

[Allen Browne]

TOP 10 in the *subreport's* RecordSource query should work fine.

Access calls the subreport independently each time it is needed, and the TOP
predicate is applied after the LinkChildFields/LinkMasterFields filter.