Print Page | Close Window

Print x number of the same label

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=4382
Printed Date: 04 May 2024 at 10:37am


Topic: Print x number of the same label
Posted By: Crystal Mas90
Subject: Print x number of the same label
Date Posted: 26 Sep 2008 at 10:30am
Hi all,
 
I'm using Crystal X (Professional Edition).   
 
Wondering if anyone's done something like this before.
 
I have a report that's currently producing one shipping label each time
it's run.  What I need to do is modify it so that the same label gets repeated x number of times by the value in a user prompt.
 
Thanks in advance for any ideas.
 


-------------
Dave Miller
Computer Management
Westbrook, CT


Replies:
Posted By: kcastillo
Date Posted: 03 Dec 2008 at 2:31am
Hi,
 
I have the same exact problem.
 
I need to print a label twice, one next to each other, to place on the corner of the package....
 
Any help?


-------------
KC

Posted By: rahulwalawalkar
Date Posted: 03 Dec 2008 at 3:49am
Hi Folks
 
Check this link it works................
 
http://www.tek-tips.com/viewthread.cfm?qid=1374954 - http://www.tek-tips.com/viewthread.cfm?qid=1374954
 
Cheers
Rahul

Posted By: kcastillo
Date Posted: 03 Dec 2008 at 4:04am

Thanks, but can this be done without using tables/alias?

 What if my x is a fixed number... I just need to print the label twice, I don't understand why a table is needed in this case.



-------------
KC

Posted By: rahulwalawalkar
Date Posted: 03 Dec 2008 at 5:41am

HI

You need to generate the details section to print the label,if you need to print the label just twice create two details section and and use the same label information in that .
 
If you need to print the details section depending on user prompts or the number you enter in the prompt then use the table......
 
Cheers
Rahul

Posted By: kcastillo
Date Posted: 04 Dec 2008 at 5:21am
Hi

I've tried several things to get both printing label types:
1. For double label
I made two detail sections and copied the same content, but it didn't work (I guessed because i'm using a label template). I redid it without the template and 2 details sections and it prints the label twice, except it's printing it one under the other and am not able to print next to each other.

2. For label based on a quantity field
Created the alias of the table that contains the quantity field.. but trying different joins...

I am getting too many rows as query result or double prints for the labels that have quantity field = 0.

Not sure what to do here. Please help.


-------------
KC

Posted By: rahulwalawalkar
Date Posted: 04 Dec 2008 at 6:24am
Hi
 
1. For double label
 
Don't create another details section if you want to place next to eachother
Use the same fields and palce them in details section on the right hand side if you want next to each other format accordingly.....
 
2. send me the report and some sample data to play around with
 
mailto:rahulwalawalkar@yahoo.com - rahulwalawalkar@yahoo.com
 
Cheers
Rahul

Posted By: kcastillo
Date Posted: 11 Dec 2008 at 5:11am
Hi,
 
I'm still having many issues with this.
 
1. Is it possible to do a normal query (without the alias) and to use crystal reports functions in order to duplicate the data of one row into x number of labels....
2. Can I use a count to generate the exact number of rows for each result i need?
 
(for example, one row has 50 labels.. but the alias query is only generating 6 duplicates for that row.  On the other hand, another row has 3 labels but the query generates 6 rows... so i'm not getting the amount of labels correct for either one.)
 

 


-------------
KC

Posted By: kcastillo
Date Posted: 14 Jan 2009 at 3:27am
This was a little help i got:
1) I create a temporary file and duplicate the record for as many times as I need the label
2) Use Crystal Data Object
3) Another solution by Ido Millet @ http://www.tek-tips.com/faqs.cfm?fid=3226

I ended up using the third option, at first I wasn't allowed to create an index table, but with a little persuasion, got it.

Thanks


-------------
KC


Print Page | Close Window