Search results for query: *

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...

Thanks again, Lisa. I checked Crystal Management Console and this is what it has: Database Name: crystal;ce8;microsoft sql server;07.00.0623 I guess I am using MS SQL Server 7.0

Hi Lisa, I wasn't responsible for setting up Crystal Enterprise and the person who was is not here. Can you please let me know if there's a simple way for me to check whether I may be using SQL server for my Crystal Enterprise? From the server terminal, I choose START -> Programs and I don't...

Hi rhinok, Thanks for replying and providing the links above! Just wanted to know, however, does Cystal Enterprise utilize Microsoft SQL Server 7.0? If not, then I probably do not need to worry about the worm and applying the service pack. Correct? Thanks again, dbew

Hi everyone, The company I work for has Crystal Enterprise 8.0 and the IT Department has informed me that there is a worm called the "SQL/Slammer Worm" which affects MS SQL Server 7.0. I was wondering if Crystal Enterprise is susceptible to this worm and what do I need to do to...

Thank you to everyone that replied to my initial post. I decided to take IdoMillet’s advice and “insert the number also as part of the Description portion to make it appear as if it's both parts” and then display just the description only. Now the parameter lists the values as the way I...