Technical Questions: "Creating" additional lines based on a total

"Creating" additional lines based on a total

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11519
Printed Date: 18 May 2024 at 4:12pm

Topic: "Creating" additional lines based on a total

Posted By: Kwirky
Subject: "Creating" additional lines based on a total
Date 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 :)

Replies:

Posted By: lockwelle
Date 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.

Posted By: Kwirky
Date Posted: 26 Oct 2010 at 1:07pm

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.