Author |
Message |
Crystal Mas90
Newbie
Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 1
|
Topic: Print x number of the same label 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
|
IP Logged |
|
kcastillo
Newbie
Joined: 28 Nov 2008
Location: Spain
Online Status: Offline
Posts: 12
|
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
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 03 Dec 2008 at 3:49am |
Hi Folks
Check this link it works................
Cheers
Rahul
|
IP Logged |
|
kcastillo
Newbie
Joined: 28 Nov 2008
Location: Spain
Online Status: Offline
Posts: 12
|
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
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
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......
Rahul
|
IP Logged |
|
kcastillo
Newbie
Joined: 28 Nov 2008
Location: Spain
Online Status: Offline
Posts: 12
|
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
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
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
Cheers
Rahul
|
IP Logged |
|
kcastillo
Newbie
Joined: 28 Nov 2008
Location: Spain
Online Status: Offline
Posts: 12
|
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
|
IP Logged |
|
kcastillo
Newbie
Joined: 28 Nov 2008
Location: Spain
Online Status: Offline
Posts: 12
|
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
|
IP Logged |
|
|