Please help,
We have a datasource which holds Membership No and ProductCode. Each membership number can have 1 or multiple product codes.
What i need to do in crystal is to show the follwing:
1. All members who have both product codes.
2. All members who have a Product code 1 and not product code 2
2. All members who have a product code 2 and not product code 1
Once i have this info i can then start generating charts to show this compartive data.
Below is the data extract from source
MembNo Product
1 ST0708
1 ST0607
2 ST0708
2 ST0607
3 ST0708
3 ST0607
4 ST0708
4 ST0607
5 ST0607
6 ST0607
7 ST0607
8 ST0708
9 ST0708
10 ST0708
11 ST0607
12 ST0607
Many thanks
We have a datasource which holds Membership No and ProductCode. Each membership number can have 1 or multiple product codes.
What i need to do in crystal is to show the follwing:
1. All members who have both product codes.
2. All members who have a Product code 1 and not product code 2
2. All members who have a product code 2 and not product code 1
Once i have this info i can then start generating charts to show this compartive data.
Below is the data extract from source
MembNo Product
1 ST0708
1 ST0607
2 ST0708
2 ST0607
3 ST0708
3 ST0607
4 ST0708
4 ST0607
5 ST0607
6 ST0607
7 ST0607
8 ST0708
9 ST0708
10 ST0708
11 ST0607
12 ST0607
Many thanks
