Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Topic: Help with sort formula 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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum