I'm working a report that will show employee anniversaries based on the employee hire date. I have grouped on the following formula.


EEName:
If MONTH({hireDate}) = MONTH(CURRENTDATE) AND YEAR({hireDate}) <> YEAR(CURRENTDATE) AND {empStatus} = "A" THEN
    {EInfo.firstName} & ", " & {EInfo.lastName}

so it looks to see that they were hired in the current month and that the employee is active and that they are not a new hire.

the group works well except for some unknown reason I am getting two blank lines.  at the top of my records. It's trying to include 2 employees that should not be included and I can't figure out why. Since they do not meet the criteria of the formula above they are coming into the report as blank lines.

I can't get rid of the lines by by doing EENameSort = 1 else 0 then sum({EEName}, {EENameSort})>0 but.....those two lines are still being counted in the totals for employee count and factored into my average for Length of Service.

any ideas on this one?

the only thing in the record select is my company filter pulling in only the company I'm looking at. 

Keep in mind suppressed data is still part of your data set and will show up in your summarized data unless you exlcude it via some other mechanism (e.g. Running Totals, Shared Variable formulas)

use a select statement to exlcude the employees you do not want to see

unfortunately this will not work for me. i can use that in my group select but then my count and average are still off since the blank records still get counted. i can't apply this to only the group in my record select either.