Print Page | Close Window

Help with sort formula Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13921 Printed Date: 05 May 2024 at 6:24am Topic: Help with sort formula Posted By: CircleD Subject: Help with sort formula Date Posted: 29 Jul 2011 at 4:48pm I have a puzzler that I have been working on for a while and finally spotted the fix (I thought).Our invoices are printed using an embedded report.The accountant has asked for some modifications and I've done all but one successfully.The last one needed is to have them print in alphabetical order.The original writer used a simple formula to sort them all as they are printed but they are by invoice number and copy number. {RWINVHDR.INVOICE_NUMB} & {RWINVHDR.COPY_NUMB}.If I change the {RWINVHDR.INVOICE_NUMB} to {RWINVHDR.BILLTO_NAME1} it works as wanted with the exception that now if there are multiple jobs with the same customer it prints them all on 1 invoice but we, as well as our customers, don't want that,we need a separate invoice for each job.I know it's probably something simple but I'm just not seeing it. Replies: Posted By: lockwelle Date Posted: 01 Aug 2011 at 3:04am {RWINVHDR.BILLTO_NAME1} & {RWINVHDR.INVOICE_NUMB} & {RWINVHDR.COPY_NUMB}

Print Page | Close Window