I am afer some help, I am a newbie with Crystal Reports (have been asked to use at my new work to update some reports printed)
We print out a lot of labels for parts and each part is assigned to a Job number. ((each job number can have multiple parts, and so there are numerous records sharing the same Job number) currently the part label prints out the job number from within the database, however I am wanting to convert these to just a Location Number (1,2,3,4,5 etc..) so that each specific job number in the database is assigned a Location number, and this is then printed instead of the Job number. (The Labels are a subreport from a main report that selects a new label for each record in the database table.)
Long winded explenation and probably not very clear, but hopefully someone understands and can explain how I can achieve this simply using Crystal Reports .
Thanks in advance.
Im not sure where to start on this