cancel
Showing results for 
Search instead for 
Did you mean: 

START DATE Twice

Former Member
0 Kudos

Hello everyone,

I have a benefit report pulling people who are enrolling in the system for the first time.

My report is suppose to pull employees with a new enrollment only, not ones who change it.

Our system puts a new CREATION DATE everytime an enrollment is created or changed, but I'm only interested in the new ones.

Usually a person who changed their enrollment would have two CREATION DATE in the table.

How can I tell Crystal to look for records and include ones with one CREATION DATE only?

Thanks so much,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Nabilino,

Did you try the DISTINCT function? Apply that to {Benefit.Employee} field.

Heather

Answers (1)

Answers (1)

Former Member
0 Kudos

You can use Group Suppression

Group1 = Employee

Group2 = Creation date (by day)

Group selection enter

creationdate = minimum( creationdate, employeegroupfield)

Remember this only suppresses records, and is OK for list reports if you want to do summaries you will need to use Running Total which evaluate on change of employee.

Ian

Former Member
0 Kudos

When I implement the above and try to write this formula:

{BENEFIT.CREATION_DATE} = minimum ({BENEFIT.CREATION_DATE},{BENEFIT.EMPLOYEE})

I get "Function cannot be used becaue it must be evaluated later" message.

Edited by: nabilino on Jul 22, 2010 7:05 PM

Former Member
0 Kudos

Is there a way to identify if the same employee has CREATION_DATE twice in the database, and based on that if so to supress their record?.

COMPANY EMPLOYEE CREATION CODE OPTION TYPE START STOP-DATE

1 10583452 6/25/2010 PPHA 25 36 1/1/2010 6/21/2010

1 10583452 6/25/2010 PPHA 25 36 1/1/2010 6/21/2010

In the example above, both records of this employee would be supressed.

Thanks much,

former_member260594
Active Contributor
0 Kudos

You could base the suppression on the count of creation dates per employee, something like this;

suppress if

count({creation date},) > 1

Former Member
0 Kudos

YOu must place this formula in the Group selection not the record selection.

Ian