Specifications

Four examples
634 InfoMaker
Here is the last page of the report, with the total number of males and females
in the company displayed.
If you want more
information
What if you decide that you also want to know the number of males and
females in each department in the company?
❖ To display the males and females in each department:
1 Select Design>Data Source from the menu bar so that you can edit the data
source.
2 Select Design>Select tables from the menu bar and open the Department
table in the Select painter workspace, which currently displays the
Employee table with the Emp_id and Sex columns selected.
3 Select the department_dept_name column to add it to your data source.
4 Select Rows>Create Group from the menu bar to create a group and group
by department name.
5 In the trailer group band, add two additional computed fields:
Sum(If(sex = "M", 1, 0) for group 1)
counts the number of males in each department;
Sum(If(sex = "F", 1, 0) for group 1)
counts the number of females in each department.