Print Page | Close Window

Shipping label prt based on detail line prt count

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14711
Printed Date: 06 May 2024 at 1:31pm


Topic: Shipping label prt based on detail line prt count
Posted By: rook
Subject: Shipping label prt based on detail line prt count
Date Posted: 19 Oct 2011 at 3:56pm
Hi all

I'm new to crystal reporting.  I have a requirement to print labels based on detail line field that holds the number of labels to print.  Example line 1 item A, number of labels to print is 3.  line 2 item b, number of labels to print is 10.  How do I go about printing labels.  Total of 13 labels would be printed. Any guidance is appreciated.

thanks
Rook 


-------------
rook


Replies:
Posted By: lockwelle
Date Posted: 20 Oct 2011 at 6:29am
this has been asked many times before, and the best answer that I have heard is to create a table/import a table that is basically:
1
2
3
4
5
6
...
 
then you can select the label and join it the number table where labels.needed <= number table.  CR will bring in the 'duplicates' and you are set.
 
The original poster had the number table as an Excel spreadsheet, we have a numbers table in our database
 
HTH

Posted By: rook
Date Posted: 20 Oct 2011 at 4:40pm
Hi Lockwelle

I understand about the table but could explain on the CR part what I would need to get it to print x number of times.  What type of could would I need to set.  Or provide me the site where I can check out the solution.

Thanks
Rook


-------------
rook

Posted By: IdoMillet
Date Posted: 22 Oct 2011 at 3:58am
See: http://www.tek-tips.com/faqs.cfm?fid=3226

-------------
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com

Posted By: rook
Date Posted: 24 Oct 2011 at 1:17pm
Hi member_profile.asp?PF=2918&FID=5 - IdoMillet

Excuse me for my lack of knowledge on Crystal.  After joining the tables with the report.  Where would I set the code to repeat the label printing at.  Is there another site I could look at.

Thanks
Rook


-------------
rook


Print Page | Close Window