Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 21, 2008 05:16 PM by lmcculloch
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?
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.