Grouping

[sim133]

Hi everybody;
I have a problem with grouping. I have three fields.
BRAND_NAME_1,
BRAND_NAME_2,
BRAND_NAME_3 for one record.
I want to be able to group by these fields.
This is what I want to do.

First group records that have the same BRAND_NAME_1 value
then group records that have the same BRAND_NAME_2 value
then group records that have the same BRAND_NAME_3 value
I am using crystal XI and oracle database.
Thanks

 

[Durango122]

hi
create a group base on brand_name


Durango122
Remember to used all fingers when waving to policemen

 

[synapsevampire]

Why doesn't inserting each of the 3 brand_name_X fields do this for you?

-k

 

[sim133]

The problem is if BRAND_NM_2, OR BRAND_NM_3 has the same value with BRAND_NM_1 then I want be able to group them togather. I didn't want to create a group base.

 

[sim133]

There fields for each BRANDNM, CHECMICAL_NM_1, CHECMICAL_NM_2, CHECMICAL_NM_3. I want to display these values if they have the same BRAND_NM