I have a report that has 2 group headings. My detail line has a formula to suppress the lines I don't want but if all the lines are suppressed for the group, the group heading still prints. My data shows:
employee name
employee location
employee salary table
job start date
job end date
employee termination date
My report is to show employees terminated during the year who were in a particular salary table. Employees can have numerous records as a result of changing jobs or locations. When an employee is terminated, the termination date is placed in all their records.
My report works like this:
Read 3 parameters. (begin date, end date and salary table)
Read in all records where the termination date is between a begin/end date parameter.
Group by location then name.
Find the most recent end date using the maximum function on all records for an employee. (This is why I have to group by employee)
Suppress the detail lines I don't want using the formula:
not(end date parameter = max end date and salary table = input parameter salary table).
Suppress the group 2 heading for employee names because the name is in the detail line.
When no records are printed for a location, the group heading for the group location still prints.
How can I prevent the location group heading from printing if the report shows no employees for that location ?
Thanks in advance for your help.
IP Logged
