Specifying Start Position for a Mailing Label

[ErinMCC]

I am creating a crystal report to do mailing labels. I want my user to be able to specify which mailing label to start printing on like they can with word. Has anyone done this before or have an idea on how I would approach this?

 

[Ngolem]

sure...consider the following label page

Label 1 label 2 Label 3

Label 4 label 5 Label 6

Label 7 label 8 Label 9

Label 10 label 11 Label 12


Assumption #1: All labels will contain the same information when printed
Assumption #2: If more than one page of labels required then succeeding pages start at Label 1

Create 2 parameters

{?Number_of_labels}
type: numeric
description: Enter the number of Labels to be printed
Default: 1

{?Start_Label}
type: numeric
description: Enter the position number of the first Label to be printed
Default: 1

Place the individual labels in a single section of a group footer with the footer designed to accomodate a full page of labels

in the conditional suppress for each label field put the following formula

Eg. For Label 1

WhilePrintingRecords;
if pagenumber = 1 then
{?Start_Label} > 1 or {?Number_of_labels} < 1
else
{?Number_of_labels} + {?Start_Label}
- 1 - (12 * (pagenumber - 1)) < 1;

Eg. For Label 2

WhilePrintingRecords;
if pagenumber = 1 then
{?Start_Label} > 2 or {?Number_of_labels} < 2
else
{?Number_of_labels} + {?Start_Label}
- 1 - (12 * (pagenumber - 1)) < 2;

Write similar formulas for all 12 labels....this should work


Jim Broadbent