I have a report I am running. I have a list of addresses. I want to display one address per label but I want the first label to be customer information. How do I make it so the first card is customer information and then all cards proceding are the addresses?
Not sure if I understand your problem or not. Are you saying you want a single label to show customer info then all subsequent labels will be addresses?
I would personally rig my SQL query using a UNION ALL where the first SELECT statement returns the record of the customer information, then UNION ALL that to the second SELECT statement that returns just the address info (excluding the customer informaiton
returned in the first SELECT).
Then Crystal can be a standard mailing label report.
squall8046
Member
1 Points
23 Posts
Creating A Header Mailing Label
Nov 21, 2008 02:23 PM|LINK
I have a report I am running. I have a list of addresses. I want to display one address per label but I want the first label to be customer information. How do I make it so the first card is customer information and then all cards proceding are the addresses?
lmcculloch
Member
110 Points
27 Posts
Re: Creating A Header Mailing Label
Nov 21, 2008 05:16 PM|LINK
Not sure if I understand your problem or not. Are you saying you want a single label to show customer info then all subsequent labels will be addresses?
I would personally rig my SQL query using a UNION ALL where the first SELECT statement returns the record of the customer information, then UNION ALL that to the second SELECT statement that returns just the address info (excluding the customer informaiton returned in the first SELECT).
Then Crystal can be a standard mailing label report.