LibreOffice Base Group 24

Reports 2

We look at grouping our report by employee ID - We also add in some space and separator lines.

We create a report from the Employees table and use "IF()" to change the Department ID to a Department Name. Then we use the "ISBLANK()" in an IF to set a value for a field that is NULL. We also highlight values greater than 40 by making them bold and changing the color.

We create a report that groups employees by their group, which is also grouped by department with each department on a separate page.

We add a count for the Group and Department groups, we also accumulate the hourly wages by Group and Department.