Attached is a COBRA report I am working on that has multiple benefits for an employee. The report is to list the Employee information, then the event of the employee's action (i.e., termination, reduction in hours, dropping a dependent, leave of absence, changing benefit levels), then the plan line will show the benefits that are changing (may they be multiple or singular changes), and the dependent information, and finally the dependent plan that is impacted.

I have the report working to the employee and dependent information, but can't seem to get the plans to appear on the report.

There are multiple layers to the formulas, see attached report and document sheet.

COBRA-Annette-New.rpt
COBRA-report-issues.docx
> after the dependent information.

What do you mean by that, exactly?

If you only want the report to include the employees with dependents, you should include {EMEB_EMP_BENEFITS.DEP_NUM

Your groups still seem odd to me.

Group 1 is on EMP_NUMBER.

Group 2 is on a combination of EMP_NUMBER and DEP_NUMBER.

It's not necessary to include EMP_NUMBER in that. You can. It doesn't accomplish anything, since group 1 is on EMP_NUMBER, but it doesn't do any harm either.

But the real issue is that groups 2, 3 and 4 are all really on the same field - DEP_NUMBER.

Group 2 might as well be just on DEP_NUMBER (since group 1 is on EMP_NUMBER).

Groups 3 and 4 are both on the same formula (Group: Dependent), which is just

{EMEB_EMP_BENEFITS.DEP_NUM

So, once again, you're grouping on a conditional formula, so you end up with a True group (where DEP_NUMBER <> 0) and a False group (where DEP_NUMBER = 0). The False group would be first (but see below). The True/False grouping is repeated for group 3 and group 4.

So, your effective grouping is just:

EMP_NUMBER

DEP_NUMBER

The formula used for groups 3 and 4 will produce either True or False, depending on the value in DEP_NUMBER. Either way, you get one group 3 and 4 for each DEP_NUMBER (either it's 0 or it's not), so groups 3 and 4 don't do any grouping at all.

Here's the grouping from the beginning of your sample report:

G1 - 11032

G2 - 11032-0 (DEP_NUMBER = 0)

G3 - False

G4 - False

G2 - 11032-1 (DEP_NUMBER = 1)

G3 - True

G4 - True

G2 - 11032-2 (DEP_NUMBER = 2)

G3 - True

G4 - True

G2 - 11032-3 (DEP_NUMBER = 3)

G3 - True

G4 - True

G2 - 11032-4 (DEP_NUMBER = 4)

G3 - True

G4 - True

G1 - 20664

G2 - 20664-0 (DEP_NUMBER = 0)

G3 - False

G4 - False

So, how does that compare to what you're really trying to do?

James