Base your report in the Credentialing Table. Relate back to the employee table to display employee info, sort by the employee key and then by date - presto! You will have all of the employees credentials together, sorted by date.
You may not need a subsummary part unless you need totals… But if you do - you can base the subsummary on the employee key.
Body parts are credentials - so all the credentials will show no matter how many there are..
Desert Dog Technology, Inc.
1 of 1 people found this helpful
On a layout for Licences table you can create a subsummary part for each of the following:
- MainTable::Department which is sorted by that field
- MainTable::Employee (Name -so long as the name is unique... or number) ... sorted by the one chosen
Then the body part will show the licence detail.
When you then sort by MainTable::Department, MainTable::Employee, Licence (date or whatever) the report should show correctly.
you both pointed out my mistake,
i was basing the report from the wrong table,
once i changed that, it worked,