Search results for query: *

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

Good Morning I am using Crystal 9 and a SQL DB and doing a report involving employee benefits and deductions. Here is my problem: There is a field in the table I'm using called "line_no" so that there are multiple records. For an example, std (short term disability) for payroll period "X"...

Hi Everyone Please disregard this post. I must've had a brain cramp or something but I figured it out. Thanks anyway. Vickie

Good Morning I am using data from a SQL database, and using CR version 9. I am doing a Human Resources report regarding pay ranges. The minimum of the pay range is whatever the hourly rate is for step 1 of the pay grade. The maximum of the pay range is whatever the hourly rate is for step 2 of...

Hi Peter Thanks for the info. I had already tried that but then it doesn't put in the text I'm asking it to so I must have a different problem so I'll need to see what else is going on in there. Thanks anyway you guys. Vickie

Hi Dave Sorry I had so many mispelled words in my post, I didn't check it prior. Do you know how I can write the formula so that it removes the thousands comma separator? The formula will work as is on the parts of the formula that don't have these commas but won't replace the amounts with...