Creating Multiple Labels

Hello everyone, 1st time poster!

I've not been using Crystal reports long and subsequently don't know much and need help.

The company i work for uses Efacs v7.2 from Exel Systems as it's ERP with Crystal Reports 7 as the report generator/writer.

We generate a works order/schedule that is sent out onto the shop floor to specify what products need to be manufactured.

This basically shows a Part Number (in both text and Barcode) a Part Description and the Quantity required to be manufactured (amongst other bits of product info).

There can be multiple products on each schedule, all different.

I am now in the process of creating a report that will generate a sticky label that can be placed on the finished products box.

So far i have successfully created a report that picks up both Part Numbers (text & BC) and the Part Desc but it only prints one label per product.

EG Schedule may say

(part number: ) BM1-CLIN (Qty: ) 16
(part number: ) CLK-SUS (Qty: ) 8
(part number: ) MLK-SUS (Qty: ) 8

At the moment i only get 3 labels. I need to find a way of multiplying the Quantity of labels required by the Quantity of the Product being manufactured - so in the above example i'd get 32 labels.

Can anyone help? Let me know if more info is required.

Thanks.In your example, would you want

16 of this label (part number: ) BM1-CLIN (Qty: ) 16
8 of this one (part number: ) CLK-SUS (Qty: ) 8
and 8 of this one (part number: ) MLK-SUS (Qty: ) 8

If you could provide a small matix of data to work from ?
also, how do you group this by Part, or ??

Creating Mailing Labels (Generic)

Can anyone advice on how to create mailing labels using SQL reporting
services?
Thank you in advanceI would use Word or other proprietary software like Page O Labels or similar :)
"Rahul Chatterjee" wrote:
> Can anyone advice on how to create mailing labels using SQL reporting
> services?
> Thank you in advance
>
>|||create a list report and export to excel and use it as a source for a mail
merge. Better yet, set up your database as a data source in Excel and do it
directly in Excel w/ microsoft Query
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:OsOMwYszHHA.5408@.TK2MSFTNGP02.phx.gbl...
> Can anyone advice on how to create mailing labels using SQL reporting
> services?
> Thank you in advance
>