Search results for query: *

Here are the new error messages. Whether I code the dateTimeVar value as [PLA] or PLA, I get the same result. //Group Header //error message says "a variable name is expected here" at the dateTimeVar array lines. I also tried dateTimeVar and I get the same result. whileprintingrecords...

Thanks for your diligence in helping me with this challenge. The {PS_JOB.EFFDT} is a type: DateTime. Does it need to be converted to just Type: Date? If yes, how would I do that? //Group Header //new error message says "A [is expected here" at the redim lines whileprintingrecords; datevar...

See error messages for each formula. //Group Header //error message says "a variable name is expected here" at the redim lines whileprintingrecords; datevar array PLA; datevar array RFL; redim array PLA; redim array RFL; stringvar output:=""; //Detail records //error message says "A date is...

This looks like a great start. I will go try it and let you know how it works. Thanks so much!

Thank you Madawc for your response. The problem is I did not know how to write the syntax so I don't have a formula. What I want my formaula to do is as follows. If the {PS_JOB.ACTION_REASON} for the first row (D1)is (PLA or LOA) then look for the fist instance where the...

The following sample data shows a Leave/Return from Leave job history report for 4 employees. The first column identifies which rows are the GH- Group Header and D-Detail. The data is grouped on ({PS_JOB.EMPLID}). What I need to determine on the Group Header row, is how many times in 2006 the...

I copied lbass' codes (exactly as given) into three formulas and placed them where indicated and IT WORKED! Thanks so much!

Thank you for these quick responses. I have never used variables before, so I will go try it now. Per synapsevampire's suggestion, below is the underlying data that generated the total. ID NAME CO Month ERNCD GRS YTD 000036 $15,460 000036 RND 9 RE1 $6,700.00 000036...

I need some help calculating the sum of a group maximum values. This is what I have… Group 1 - Group data by EMPLID Group 2 - Group by Company Code For each company, the employee has accumulated monthly earnings. So to get the maximum earnings per company I do step 3. Step 3 - Insert...

I need some help calculating the sum of a group maximum values. This is what I have… Group 1 - Group data by EMPLID Group 2 - Group by Company Code For each company, the employee has accumulated monthly earnings. So to get the maximum earnings per company I do step 3. Step 3 - Insert...