How to Handle multiple logins for same user

[geestrong]

I am using CRXI and Oracle DB 8

Hello I am trying to figure out how to combine two login for the same employee. There are several users on the system that have two logon. Example Joe Doe as JAD and JDOE log on. The user I am developing the report for only wants to see them one. I need to combine these two log on. I have the users Full Names displayed in group and the John Doe appearing twice in the report.

Here is code that gets the user names:
@ConCatName

if {PER_ACTIVITY.PER_ACT_ASGN_TO} in ['LC','LCHAMBERS']
then {EMPL.EMPL_FNAME}+ ' '+ {EMPL.EMPL_LNAME}
else
if {PER_ACTIVITY.PER_ACT_ASGN_TO} in ['RMC','RCAMP']
THEN 'ROBIN CAMP'
ELSE
{EMPL.EMPL_FNAME}+ ' '+ {EMPL.EMPL_LNAME}


I use this Code to create the group
@txtHeadingAssignedTo
if not isnull({@ConcatName}) then
'Assigned to '&{@ConcatName}
else
'Assigned to '&{PER_ACTIVITY.PER_ACT_ASGN_TO}

Thanks

 

[lbass]

It is unclear what the problem is. If you use your formula for a group and suppress the details section, you will have only one occurrence per person.

-LB

 

[geestrong]

The report is based on the login of the employee. I am suppressing the detail section. The group section contain the the employees with two logons: The Group is made up of the the logon associated with the First and Last name

Robin Camp has the following logons RMC and RCAMP. I need to combine the two logons.

Greg

 

[Turkbear]

Hi,Define what you mean by 'combine the 2 logons' --

In your example, don't the groups become named by the formula..So, all the data related to either logon would be in the Groups details under 1 Group Header - for instance, under Robin Camp , right?










To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You should group on the formula. Then if you want to display the actual logins in on one line, use formulas like:

//{@reset} to be placed in the {@name} group header:
whileprintingrecords;
stringvar login := "";

//{@accum} to be placed in the detail section}:
whileprintingrecords;
stringvar login := login + {table.login} + ", ";

//{@displ} to be placed in the group footer:
whileprintingrecords;
stringar login;
left(login, len(login)-2);

Then drag the grouphame into the group footer and suppress the detail and the group header.

-LB

 

[geestrong]

Thanks for the response... I had a major brain dump and once it reboot I got the solution

I used the information from the employee table...duh thanks Turkbear and lbass