Recent content by dbew

Just to refresh your memory, synapsevampire, this is what you initially suggested to me: If you have a date field that shows when he left, then add something akin to the following to the record selection formula (Report->Edit Selection Formula->Record): isnull({yourtable.yourexitdate})

Thanks synapsevampire. You initial idea, about choosing only the records without an Assignment End Date, is worth looking into. Currently the field which houses this information is not populated. Perhaps we should expedite this task. Do you agree?

"Dedupe"? Unfortunately, I am not familiar with this term. Could you please explain?

This is a follow-up question regarding a mailing labels issue that was addressed here last week. I have successfully created a Crystal report (Version 8.5) containing mailing labels for current worksite addresses. “Current” because participants, who are assigned to these worksites, can enroll...

synapsevampire & Howard, I enter this formula in the Group Selection Formula Editor instead: {table.assignmentdate} = maximum({table.assignmentdate},{table.socialsecurity}) Amnd it worked. Thanks!

Does anyone know why I get the following message in the Record Selection Formula Editor: This function cannot be used because it must be evaluated later. I've grouped my records by Social Security Number and I wish to only have the most recent Assigned Date. This is the formula I am...

synapsevampire & Howard, When I enter this formula: {table.assignmentdate} = maximum({table.assignmentdate},{table.socialsecurity}) I get this message after checking for errors: This function cannot be used because it must be evaluated later. Did I miss a step? I created a group using SS#...

Thanks, synapsevampire! If you wanted to know my experience with this report, I've been trying to perfect it for some time. My original course of action was to suppress the inactive worksite labels using the following formula: Not onfirstrecord and {ado.EMPLOYEE.FICA-NBR} = previous...

And synapsevampire, just want to make sure: You typed: {table.assignmentdate} = maximum({table.Participant Enrollment Date},{table.Participant Social Security Number}) Did you purposely use {table.Participant Enrollment Date}? Or should that also be {table.assignmentdate} like Howard had it...

Right. I just wanted to make sure that creating a grouping and suppressing will not affect this. Thank you for confirming!

synapsevampire & Howard, Okay, so these are the steps I need to perform: 1. Group by SS# 2. Add the following to the Record Selection formula: {table.assignmentdate} = maximum({table.Participant Enrollment Date},{table.Participant Social Security Number}) 3. Suppress the group header and...

Question: I'm kinda still new in Crystal. How would I create a MAX summary field?

Thanks you guys! Let me try this and get back to you! THANK YOU AGAIN for taking the time to help me out!!!

Thank you for the suggestions, synapsevampire and Howard! synapsevampire, I am pulling from two tables from our ERP called Lawson 7.2.2.4 (running off of an AS/400 database): Table 1: Participant Name Participant Social Security Number Participant Enrollment Date Assigned Worksite ID Table...

Hi everyone, Our database has a table that contains participant records. For some participants, there will be more than one record associated with his/her Social Security Number. This is due to the fact that our participants can re-enroll in our program and are assigned to various...