on 07-22-2010 12:13 AM
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,
Hi Nabilino,
Did you try the DISTINCT function? Apply that to {Benefit.Employee} field.
Heather
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.