I have two tables to a mailing label report. One table I am pulling the Customer address info. The other table has a date that I am filtering by. I'm receiving multiple addresses. I know why... The "other" table has an ID attached to each record. What I need to do is be able to get the max ID for each client from the "other" table. I would like to be able to do the selection through crystal and not SQL if at all possible.
EX.
Customer Table
cust 1
add 1
city 1
state 1
zip 1
cust 2
add 2
city 2
state 2
zip 2
"Other Table"
id 1
cust 1
id 2
cust 1
id 3
cust 1
id 4
cust 2
id 5
cust 2
id 5
cust 2
I want the records
id 3
cust 1
and
id 5
cust 2
So I cannot simply do a select Max()...
Any ideas?
I have tried grouping on the report but the labels do not fill out correctly...
EX.
Customer Table
cust 1
add 1
city 1
state 1
zip 1
cust 2
add 2
city 2
state 2
zip 2
"Other Table"
id 1
cust 1
id 2
cust 1
id 3
cust 1
id 4
cust 2
id 5
cust 2
id 5
cust 2
I want the records
id 3
cust 1
and
id 5
cust 2
So I cannot simply do a select Max()...
Any ideas?
I have tried grouping on the report but the labels do not fill out correctly...