Printing one Record on Many Labels 2

[WilGrl]

Hi there,

This is my first post on the forum so I appoligize if I neglect to include any information. I am using Crystal reports 10 to print labels that will be stuck on inventory pallets.
The report runs off a simple table that holds product SKU information and pallet dimenions. I have been give laser labels consisting of a sheet of 4 labels. I have setup the report to pull in product SKU and dimensions based on the SKU chosen by the user as a parameter.

I need to let the user determine how many times the record will print. For example, if they choose 4 than the whole sheet will be filled with the same label. If they choose three than the same product will print out three times.

I would appreciate any help that can be provided.

Thank you.

 

[crystalreporting]

This is kinda tricky, and not really supported by Crystal. You mention above that the user could enter 3 or 4 (or some other number I presume). Is there any chance that this is a quantity that's stored in a database somewhere (e.g. qty to ship)? If that's the case, then this problem becomes a lot easier but it involves creating another table in your database. Create a table with one or more records for each number e.g.

Number
------
1
2
2
3
3
3

and so on....

Then in your Crystal report, link the qty field (assuming there is one you can link to) to the value in your newly created table. Your report will then find two records if the qty in your from table is 2, three records if the qty is 3 and so on. This will then give you the required number of labels.

If you can use ODBC, then you can create your table differently e.g.

1
2
3
4

and so on... then link your table using the 'less than' join type.

Peter Shirley

http://www.linkcorp.com

 

[synapsevampire]

Crystal doesn't fabricate rows, which is your requirement.

Here's a thread on modifying the tables to handle this:

thread149-100858

And here's a FAQ:

faq767-5071

The point is that you need the right amount of data, which is based on the type and layout of the database, which is always helpful to know.

Another cheat would be to NOT use the Crystal Labels function, and instead use numeroud detail sections with the DET A, C, E, G etc. using a Underlay following section, and then use a counter to keep track of the number of labels printed, as in:

DETAILS A

<fields>


DETAILS B
<FIELDS>

The underlay will place them alongside each other.

Then in each Details section use the following to suppress the fields

whileprintingrecords;
numbervar Counter:=Counter+1;
If Counter > {?LabelsNeededPrompt} then
true
else
false

I did a quick test and it worked for me.

-k

 

[WilGrl]

Thank you both for your suggestions. I tried the idea that sybapsevampire suggested and it worked for me.

Thanks again for all your help.