Recent content by VickieT

Please disregard - I have my answer. Thanks anyway.

Help - have a string field I need to convert to a number field. Can anyone help?

Synapsevampire I tried the formula you gave and it worked beautifully! Thanks so much for once again saving me on this one. Vickie

Synapsevampire you are so AWESOME! You always come through in the pinch. Example Data {ESYAPPTR.status} = "A" (this will report on the employees who are active. The problem is that I am not reporting on any date field just a date range which doesn't correspond to any field. My...

Hello I am using Crystal 9 and a SQL DB. I have to create a report to show all active employees during the period August 13, 2004 and August 20, 2004. I have a table and field for the active status but I'm not reporting on a date field from the database just a time frame that I need to...

Hi LB Thanks for the response, I'll give it a try. Vickie

Hi Martin Thanks again for the help. I didn't have "new page after" turned on and it still will only give me one of the plans. I guess I need to know how you would get it to give two separate codes and their specific data when the codes and data come from the same field, in this case...

Hi mrees - thanks for your post and I tried this but it prints each letter header and retiree name and address on one page then each {ESYEMBDD.BENDED_CODE} on a separate page. Thanks though. Vickie

I am using Crystal 9 on a SQL database pulling data from our Eden Financial software. Each month employees who are retired pay an insurance premium for health care which, in the database, is called a deduction amount {ESYEMBDD.DED_AMT}. This amount is for their medical plan which is called the...

Synapsevampire I am not the original poster of this question but you helped me solve a problem that has been hanging over my head for days. Thank-you so much. Vickie

Thank you both so much. I have about 20 reports that this was causing an issue with and now they are all perfect. Thanks again.

LB thank you sooooo soooo much for your help. This worked perfectly. Can you tell this Crystal newbie why the parentheses made the difference? Thanks again, as always, this forum is a lifesaver!

Hi Everyone I'm using Crystal 9 against a SQL database with Eden Financial Systems and reporting on Benefits and Deductions. We have employees who retain their benefits until the end of the month of their termination (this is their benefit_end_date and should be included in the report I'm...

Hi Bill Thanks for your response. Yes, it would be great to have another Eden source out there to network with. Vickie

Good Morning My subject was too long to fit completely so I apologize if it was incomplete. I am using CR9 against a SQL database (Eden Financial Software) My customer needs data for Benefit/Deductions of employees insurance premiums for two payperiods each month and totaled so that she can...