Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Creating" additional lines based on a total

Status
Not open for further replies.

kwirky

MIS
Apr 22, 2010
85
AU
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 :)
 
It sounds like just a total. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

If you are wanting blank lines, you can do this using extra sections, shown or suppressed depending on the total.

If that's not it, please explain again what you are after.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Please see Ido Millet's faq on this topic: faq767-3227.

-LB
 
Thanks for your reply. I ended up using additional details sections which I supressed according to what I wanted the total number to be.
Thanks so much for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top