Max Function Question...

[ChiTownDiva]

Hello All...

I've got a weird one...

I need to group employees by their Area Manager:

Manager Resp Code Grade
Smith AE503000 59
Torey AE504A00 59

Each Area Manager has supervisors and employees:

Smith AE503000 59 (Area Manager)
Larabie AE503301 57 (Supervisor)
Perez AE503301 30 (Employee)

Torey AE504A00 59
Tinley AE504A31 57
Umbrich AE504A31 32

What I need to do is group ALL of Smiths' employees together with Smiths' name as a group header. I figured out how to get the employees to pull together under Smith's responsibility code--I used the following formula as a group:

Left({resp_cd}, 5)

But what I need to show is Smith's Name in the header--not his responsibility code.

Does anyone have any ideas?

Thanks in advance.

ChiTownDivaus

 

[Madawc]

In Crystal 8.5, the default is to put the group name in the group header. But you are free to delete it and replace it with another value like name.

Madawc Williams
East Anglia, Great Britain

 

[ChiTownDiva]

Thanks Madawc...

But my dilehma is how to correlate the first 5 characters of the responsibility code to the Area Sales Manager. Everyone has at least 8 characters to their responsibility code and the 1st five signify an Area Manager...

ChiTownDivaus

 

[Madawc]

Group on the responsability code, but show the manager name in the group header.

If necessary, you could use a subreport in the group header to get the manager name.

Madawc Williams
East Anglia, Great Britain

 

[Reebo99]

In your example, the Area manager code would always be the first in a record sort by Resp code, If this is always the case then :

Goto Report > Record Sort sort ascending by Resp Code.

Place the name field in the group header. This will only show the value of the first record, and this should be the Area Manager.

Hope this helps, let me know how you get on.....



Reebo
Scotland (Sunny with a Smile)