Selecting proper Group description 1

[MJV8198]

I am selecting a variety of of data from order lines. I use 2 of the fields to group the data, the 2 fields are.

Group 1 {Oeel.prodcat}
Group 2 {Oeel.salesterr}.

Both fields are string fields that contain numbers. These fields are both Linked to {SASTA.codeval} however in the SASTA table they have different Codeiden values
{Oeel.prodcat} would have a codeiden of "C"
{Oeel.salesterr} would have a codeiden of "z"

When I select records I select SASTA records as follows:

{sasta1.codeiden} in ["c", "z"]

How do i get the correct description from the sasta table for each group?

Example: I have a prodcat value 001 and a Salesterr value of 001

the report produces group descriptions
as follows:

GH1 Mothballs
GH2 Mothballs
GH2 Mothballs
GH2 Mothballs
Gh2 Mothballs


it should be
GH1 Mothballs
GH2 North
GH2 South
GH2 East
GH2 West

I do not have a problem when I am only pulling 1 code identifier from the SASTT table but on this report i am pulling 2 so i get the wrong description


Thank you in advance for your help.

 

[hilfy]

Instead of using the default "group name" object that Crystal will automatically put in the header, delete that and use the field that contains the correct header lable.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[fisheromacse]

I think you will need to add the table twice, one joined to the prodcat table and one joined to the salesterr table.
you will then change your GH2 to the appropriate field linked to the appropriate table.