Recent content by franceshd

THANKS again. I have saved this post and will email to our vendor. Have a good night !

THANKS, Turkbear! I bet that is just what I need. Unfortunately, it gave an error message for needed dll's and "The feature you are trying to use is on a CD-ROM or other removable disk that is not available. Insert the CR-X1 disk and Click OK" I will speak to our software vendor tomorrow...

Anyone know a way to get a cross reference listing of where a field, definition or formula is used in CR, both in main program and subreports? Either as a separate add-on tool from some software company or something already in CR. A newbie, I almost always use CR Wizardry instead of SQL...

OH. Okay. Will try it when I get a few minutes. Gave them that report and have go on to putting out another fire- a report for the IRS on non-teacher staff with a specific type of retirement program. THANKS AGAIN, LB !!! Happy October!

Hallelujah !! I FINALLY GOT IT ! What finally worked: Stringing the Job1 GLCctrs together If InStr (Job1GLCctrs, Job10GLCctr) > 0 THANKS AGAIN, LB. I learned a lot more from your help. Things are getting easier but it is like pulling teeth. Since my boss and I had 30 years COBOL...

OH, after a good night's sleep, now I see what you mean !!! But just the count itself is not quite the answer. See the GL CostCenter is NOT a key. It a a portion of the whole GL number- like 0144-7-2210-140-800-0168-000 ****...

NOPE. cannot use PREVIOUS() function in group select Guess I'll just hold each rec-1 GLCCtr as a variable and compare each rec-10 to them. THANKS for all the effort you expended trying to help dumb me. Believe it or not, I have to help my boss with her CR. THANKS AGAIN! Have a great evening!

Sorry I had to catch my bus and then got groceries. SORRY I havent been clear enough. The report is showing everyone with at least 1 rec-1 and at least 1 rec-10. But the report should only show those whose Rec-10 GLCCtr does not have a match in a Rec-1 GLCctr OHHHH. Maybe it needs to sort by...

ok. Ive done it and it looks good. What's next please ? THANKS

So this code is counting the number of Rec-1 pay records and then the number of GLCctr records. But how does comparing their counts let you know if any of the Rec-10 GLCctr records are different from the Rec-1 GLCctr recs ? THANKS

Employee 1: All info since rec-10 CostCtr 33 does not have any corresponding rec-1 CC 33 Employee 2: Suppress since all rec-10's have a corresponding rec-1 CC Employee 3: All info since none of the rec-10 CostCtrs have a corresponding rec-1 CC THANKS SOOO MUCHHHH, LB !!!!!!!!!!!!!!!!

OK. Teacher works in 3 schools. Mon-Tue at school A, Wed-Thurs at school B and Fri at school C. So she has 1 primary salary job record Rec-1 And she has tenure so she has a supplemental salary job record Rec-10 For primary job Rec-1, there are 3 Corresponding General Ledger records with Rec No...

How can I send a file- dont have a url for the attachment space below? Is there a way to access each cell in the crosstab? THANKS

Sorry. No 1 - both. 2 diff sal recs (1 and 10) AND if each rec's corresponding GL Cctr nos are different. The info is in different tables- a salary table and a GL table. They are linked by Emp No and Sal No (1 or 10). There can be multiple GL recs per sal type - ie, a teacher can be at 1...

HELLO! Guess who, again? Now they want only those with BOTH pay types AND if the CostCenter portion of the General Ledger numbers are different between the rec-1s and rec-10s (GLCctr := Mid ( {Command.GLACCT}, 21, 4 ). I created (my FIRST!) crosstab and each employee's looks great. For...