Search results for query: *

CRV10 - I have a history table that shows changes made, the date the change was made, and the sequence nbr. Let's say on 10/1/2004 an address changed to 187 Woods Lane (SEQ_NBR = 1) and for whatever reason, another change was entered that same day changing the address yet again to 189 Woods...

Thanks for your suggestion. The application was not built in house. The table is a history table where each numeric value means something different. I'm very interested in your suggestion but I could not find "Visual Linking" in Crystal V10. When I click on Database, that is not a choice.

That worked. Thanks so much for your expertise!

Excellent - worked like a charm. Thanks so much for your expert guidance! I have one more question. What if I need to put a hundred of these if statements in this formula, is there any way to shorten the formula or use "OR" instead of an if statement for each one? Thanks again!

CRV10 - I have a {HRHISTORY.FLD_NBR} field this is numeric. In my report I do not want the numeric to print but instead I want to replace it with text. When I try to use this formula, I get the message "A Number is required here" and the "14" is hi-lighted. I would appreciate some guidance...

CRV10 - I'm not sure if this is possible, but if it is, you guys will know! I have a LAST_NAME field that may include hyphenated last names, such as Olsen-Wright. I need to remove everything in front of Wright and have the result for the field be "Wright". Not sure how to do this since the...

Thanks everyone for your help - I can always count on this group! The loop worked great!

CV10. I have a LIC_NUMBER field that is string 20. The field can contain alpha, nbr, dashes, slashes and/or blank spaces, for example 220-846 RN. The data in this field is various string lengths. Each entry will be different, some with spaces, some with dashes, some with slashes and some...

CRV9 - I need to write a turnover report. Turnover in this case will be based upon the nbr of employees on the first day of the month and the nbr of employees on the last day of the month. I'm stumped. I would appreciate any suggestions on how to do this. Thanks!

Thanks to you both!

CV9. I'm probably making this a lot harder than it has to be and once again I am turning to you experts out there. My report must list active employees between 1-1-2004 and 6-1-2004. The only thing I can think to do is to exclude employees with a term date < 1-1-2004 or a term date > 6-1-2004...

CV9 - I have a wage report that I need to show only the top 20 highest total wages for the year. A parameter will ask the user to enter the year they want to report on. The report is grouped by employee. There is a 2nd group that has the sum of all the employee's wages for the year. I would...

I got the first one to work - thanks everyone!

Thanks for the suggestion but I couldn't get that to work for me. Any other ideas?

CV9. I have a long text field 00000000000115360+ in which I'm only using the ending digits less the +. For example, using the formula below, the above string would result in "115360". I then need this result converted to 11.5360 My formula thus far is...

C V9 - could someone possibly provide a formula for calculating years of service? The report will ask the user to enter a date range to find years of service 05, 10, 15, 20, 25, 30, 35, 40, 45, and 50. Thanks so much!

Excellent! That gave me what I want. I can always count on this forum - you guys are great! Thanks so much everyone!!!!!

Again, thanks so much for your help! I'm still not there yet though. The csv file is bringing in the date 20050105 from the database as a general field instead of a date field. I know this is not an idea situation but I'm trying to work with what I have. I do appreciate the ideas. The...

Thanks so much! When I use the datediff formula, the editor hilights the field portion of the formula {PA340___ALL.LogEffectDate} and says "A date is required here". My source document is a csv file - does that make a difference?

CV9 - I am trying to find the number of days from the effective date field to current. When I put the formula below into the report, I keep getting this message: "The number of days is out of range". CurrentDate - {PA340___ALL.LogEffectDate} Does anyone have any ideas on how I might fix...