I am running CR 8.5 pulling data from SQL 2000 through ODBC.
I have a set of mailing labels that is pulling information from a consolidated file. This file is ASTU4D50. In this field I have....
Family Number
Parent Name
Address
City, State Zip
I have suppressed the Family Number because I do not want that to show on the labels. The reason why I have that in there is because I need to use this as a Unique field. I may have 4 Jane Doe's, one with 2 children in her family and 2 that have single children. (Jane Doe will show up for each student in my ASTU4D50 file)
Here is an example of what the labels would look like
5554422
Jane Doe
4860 Makebelieve Dr
Fargo, ND 58104
5554422
Jane Doe
4860 Makebelieve Dr
Fargo, ND 58104
5553311
Jane Doe
500 Made Up Rd
Fargo, ND 58102
5552200
Jane Doe
205 Makeshift Lane
Fargo, ND 58103
You can see that the first two Jane Doe's are actually the same person because the Family Number is the same. So, how do I keep that second lable from printing by using the Family Number?
Thanks in advance!
I have a set of mailing labels that is pulling information from a consolidated file. This file is ASTU4D50. In this field I have....
Family Number
Parent Name
Address
City, State Zip
I have suppressed the Family Number because I do not want that to show on the labels. The reason why I have that in there is because I need to use this as a Unique field. I may have 4 Jane Doe's, one with 2 children in her family and 2 that have single children. (Jane Doe will show up for each student in my ASTU4D50 file)
Here is an example of what the labels would look like
5554422
Jane Doe
4860 Makebelieve Dr
Fargo, ND 58104
5554422
Jane Doe
4860 Makebelieve Dr
Fargo, ND 58104
5553311
Jane Doe
500 Made Up Rd
Fargo, ND 58102
5552200
Jane Doe
205 Makeshift Lane
Fargo, ND 58103
You can see that the first two Jane Doe's are actually the same person because the Family Number is the same. So, how do I keep that second lable from printing by using the Family Number?
Thanks in advance!