Label printing in Crystal for same record

[Newbie2004]

Hi,

I would like to print labels from Crytsal, however, sometimes I want to print only one label and sometimes I want to print more than one. The labels are devided into two parts in the A4 sheet of paper(two lables into one sheet), how do I do this? I have also have a running couter at the end of each label indicating the number of label,so if its one it will print one nad if its the second label, it will print 2 and so on.

In brief my requirements are

1. Able to print either one or two labels on one sheet for same record

2. Able to count the label sequentially and print the number respectively.

Any suggestion would be appreciated.

Thanks.

CR. v. 8.05
Source BaaN C4 & Oracle 8

 

[dgillz]

Create a table called "numbers" and it should have one field. The field should be populated with the numbers 1 thru 100, or whatever you consider the maximum number of labels you will ever need.

Link this table to your existing table on a field that will never equal the value in numbers, using a not equal to join. This will create 100 labels.

Then insert a parameter field for the # of labels you want.

Finally, conditionally suppress all the labels in excess of the parameter field, or use the record selection formula to get the # of labels you want.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[GJParker]

If you are certain you will only ever need a maximum of 2 labels.

You could just add the identical label data onto the report twice and suppress the 2nd one based upon a parameter when required.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Newbie2004]

Hi dgillz,

Where do I create the table in Oracle or BaaN?Since I am logging to crystal via the baan client.

Thanks.

 

[Newbie2004]

Hi GJParker,

I will need more than 2lables and how do I suppress the 2nd one based upon a parameter when required?

Thanks

 

[GJParker]

Do you know the maximum number of labels you will require ?

To suppress fields based upon a parameter

Create a number parameter, and then you would enter a suppression formula against label 2 fields

{?ParamLabels} < 2

This will suppress these fields if 1 or 0 is entered.

similarly on label 3 fields would use a suppression formula of

{?ParamLabels} < 3

dgillz method is simpler and more flexible and i would recommend oyou attempt this route first, you will need your dba to create a new table in the Oracle db if possible.

Or if you can report from external files via Baan you could just as easy create a spreadsheet containing the table information.

HTH

Gary Parker
MIS Data Analyst
Manchester, England