Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Shipping label prt based on detail line prt count Post Reply Post New Topic
Author Message
rook
Newbie
Newbie


Joined: 17 Aug 2011
Online Status: Offline
Posts: 3
Quote rook Replybullet Topic: Shipping label prt based on detail line prt count
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
rook
Newbie
Newbie


Joined: 17 Aug 2011
Online Status: Offline
Posts: 3
Quote rook Replybullet 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
IP IP Logged
IdoMillet
Groupie
Groupie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
Quote IdoMillet Replybullet 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
IP IP Logged
rook
Newbie
Newbie


Joined: 17 Aug 2011
Online Status: Offline
Posts: 3
Quote rook Replybullet Posted: 24 Oct 2011 at 1:17pm
Hi 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.030 seconds.