Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help with sort formula Post Reply Post New Topic
Author Message
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet 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.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 01 Aug 2011 at 3:04am
{RWINVHDR.BILLTO_NAME1} & {RWINVHDR.INVOICE_NUMB} & {RWINVHDR.COPY_NUMB}
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.047 seconds.