Topic: "Creating" additional lines based on a total Posted: 25 Oct 2010 at 6:22pm
Hi, I need to create additional lines in a report based on a field number. I have a field [Boxes] which shows the total number of boxes that will be used for a delivery. This is shown in the table "BoxLabels" as a total number per job. Job number 12345 has 10 in field Boxes which means that there are 10 boxes to be delivered for that job number. I am trying to create a delivery manifest which shows job number and number of boxes (amongst other fields which do not matter for this question). I want to be able to enter 10 lines under job number 12345 to represent each box. The report will show all jobs and how many boxes, some have 1, some have as many as 15, so this varies.
Is there anyway to be able to do this? Thank you :)
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 26 Oct 2010 at 3:17am
are the lines something meaningful, or is just line1, line2.
if they are meaningful, I would create a string, with the CRLF in them after each entry, then I would just display them in a textbox with Can Grow enabled. Otherwise, I would have a loop the creates the text of fairly meaningless info and display that.
Each relevant line would have a label code on it (like a consignment number).
I can get the report to look right in CR XI and export as an excel (data only) which is great, by using many formulas detail sections and suppressing as necessary.
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
IP Logged
