Loop Syntax

[RedHeadedStepITChild]

Having trouble with a loop in CRXI

My report lists all the employees in the company. It is sorted by division and then by hire date.

Currently, the Employee ID numbers are all over the map. I need to create a new employee ID number based on division and hire date to sequentially list the new employee ID number. I have 3 divisions: 1, 4, and 6. Divisions 1 and 4 need to be in the same group, and then 6 needs its own sequence. Divisions 1 and 4 start with the number 100000 and division 6 starts with number 60000

I know my syntax is off, but here it is:


whileprintingrecords;
numbervar RSLEmpID := (RSLEmpID + 100000) + 1;
numbervar IFSEmpID := (IFSEmpID + 600000) + 1;

If {WEM.EMCMPN} in [1 to 4] then
Do
(
RSLEmpID
)
While {WEM.EMCMPN} in [1 to 4]
Else
Do
(
IFSEmpID
)
While {WEM.EMCMPN} = 6

I know what I want Crystal to do, just don't know how to tell it to do it.

Thanks

 

[lbass]

Try:

whileprintingrecords;
numbervar RSLEmpID;
numbervar IFSEmpID;
if {WEM.EMCMPN} in [1,4] then
RSLEmpID := RSLEmpID + 1 else
if {WEM.EMCMPN} = 6 then
IFSEmpID := IFSEmpID + 1;
if {WEM.EMCMPN} in [1,4] then
RSLEmpID + 100000 else
if {WEM.EMCMPN} = 6 then
IFSEmpID + 600000;

-LB

 

[RedHeadedStepITChild]

That worked. I had thought about doing it that way, but to me, it seemed if I used the If Then Else statement, it would just give me 100000 + 1 or 600000 +1 for every record, and that is why I tried to use the loop.

Can you point out where my formula is off?

Thanks for your help!